oracle SYS.DBMS_SYS_SQL 错误怎么解决
Connected.
SQL> EXECUTE dbms_tts.transport_set_check('ALL_JAVA_IMPLEMENTS', TRUE)
BEGIN dbms_tts.transport_set_check('ALL_JAVA_IMPLEMENTS', TRUE); END;
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_SYS_SQL", line 899
ORA-06512: at "SYS.DBMS_SQL", line 19
ORA-06512: at "SYS.DBMS_TTS", line 815
ORA-29304: tablespace 'ALL_JAVA_IMPLEMENTS' does not exist
ORA-06512: at "SYS.DBMS_TTS", line 844
ORA-06512: at line 1
请问应该怎么解决呀！！！！！
最新回答
牵一缕阳光
2024-09-30 07:05:59
第一个参数应该是tablespace,不能是view
This procedure checks if a set of tablespaces (to be transported) is self-contained. After calling this procedure, the user may select from a view to see a list of violations, if there are any.
Syntax
DBMS_TTS.TRANSPORT_SET_CHECK (
ts_list IN VARCHAR2,
incl_constraints IN BOOLEAN DEFAULT FALSE,
full_check IN BOOLEAN DEFAULT FALSE);
Parameter
Description
ts_list
List of tablespace, separated by comma.
incl_constraints
TRUE if you want to count in referential integrity constraints when examining if the set of tablespaces is self-contained. (The incl_constraints parameter is a default so that TRANSPORT_SET_CHECK will work if it is called with only the ts_list argument.)
full_check
Indicates whether a full or partial dependency check is required. If TRUE, treats all IN and OUT pointers (dependencies) and captures them as violations if they are not self-contained in the transportable set. The parameter should be set to TRUE for TSPITR or if a strict version of transportable is desired. By default the parameter is set to false. It will only consider OUT pointers as violations.
Examples
If the view does not return any rows, then the set of tablespaces is self-contained. For example,
SQLPLUS> EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('foo,bar', TRUE);
SQLPLUS> SELECT * FROM TRANSPORT_SET_VIOLATIONS;
热门标签
