A SQL*Loader execution has failed before completing a load to a partitioned table with local and global indexes. Which result can you expect?
Both local and global indexes are marked unusable. • Evaluate this CREATE INDEX statement: CREATE INDEX storm_track_indx ON storm_track (storm_id) LOCAL (PARTITION P1 TABLESPACE user_data1, PARTITION P2 TABLESPACE user_data2, PARTITION P3 TABLESPACE user_data3); If partition P3 is marked as unusable, what is true about subsequent operations? You can execute SELECT or DML statements that require the index as long as they do not access the P3 partition.
Related Questions
- I just created a local copy of human dbSNP, but my routine failed to load files such as SubSNPSeq3_p2, SubSNPSeq3_p2_human and the like. Are the files broken down into subsets?
- A SQL*Loader execution has failed before completing a load to a partitioned table with local and global indexes. Which result can you expect?
- What is the difference between a Local temporary table and a Global temporary table? How is each one denoted?