The code that is saved does not include the schema prefixes for either the index or the table. We segregate our indexes from the application indexes and need to see the index name prefixed with the schema where the index resides and the table name prefixed with the schema where the table resides, these are different for most of our indexes. The file that is put into VSS should be the DDL for the index and should respect the extract DDL settings ideally.
Below is what is being saved into VSS from SQL Navigator:
CREATE INDEX INDEX1 ON TABLE1
(
COLUMN1 ASC,
COLUMN2 ASC
)
NOPARALLEL
LOGGING
/
Below is what we would expect to see, given that this is how we extract index DDLs. The schema name prefixing and the tablespace identification in red are what is critical and is missing from the source that was saved to VSS.
CREATE INDEX schema1.index1 ON schema2.table1
(
column1 ASC,
column2 ASC
)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE batchjob
STORAGE (
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS 2147483645
)
NOPARALLEL
LOGGING
/
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center