Previous Topic Next topic Print topic


WE065: Unrecognized value value for SQL_OPTS command in group number, groupname.

Export found an illegal setting in the batch file. The syntax of this command is:
SQL_OPTS = statement-type [, statement-type, ...];

where statement-type is one of the following types:

CREATE (CREATE TABLE and CREATE VIEW commands)
INSERT (INSERT INTO commands)
INDEX (CREATE INDEX commands)
SYNONYM (CREATE SYNONYM commands)
CHECK (ALTER TABLE...CHECK commands)
COMMENT (COMMENT ON commands)

For example:

SQL_OPTS = CREATE, INDEX;

selects CREATE TABLE, CREATE VIEW, and CREATE INDEX SQL commands for use in the target file.

Previous Topic Next topic Print topic