|
-
I tried that and now I get this error:
ORA-00904: "OWNER": invalid identifier
ORA-06512: at "SYS.DBMS_SQLTUNE", line 5219
ORA-06512: at line 2
I looked at the unpack_stgtab_sqlset proceduer in the dbms_sqltune package and it only has this:
PROCEDURE unpack_stgtab_sqlset(
sqlset_name IN VARCHAR2 := '%',
sqlset_owner IN VARCHAR2 := NULL,
replace IN BOOLEAN,
staging_table_name IN VARCHAR2,
staging_schema_owner IN VARCHAR2 := NULL);
The documentation says that leaving the sqlset owner blank will apply it to the current shema which is what I want. The staging table does not have a field called owner.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|