On Jun 8, 3:15 pm, "jms.n..._at_gmail.com" <jms.n..._at_gmail.com> wrote:
> Running dbms_tt.transport_set_check as sys generates an error:
>
> SQL*Plus: Release 9.2.0.7.0 - Production on Fri Jun 8 15:13:00 2007
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter password:
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
>
> SQL> connect sys_at_DEV as sysdba;
> Enter password:
> Connected.
> SQL> execute dbms_tts.transport_set_check('USERS,INDEX', true );
> BEGIN dbms_tts.transport_set_check('USERS,INDEX', true ); END;
>
> *
> ERROR at line 1:
> ORA-01001: invalid cursor
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 819
> ORA-06512: at "SYS.DBMS_SQL", line 19
> ORA-06512: at "SYS.DBMS_TTS", line 789
> ORA-29304: tablespace 'INDEX' does not exist
> ORA-06512: at "SYS.DBMS_TTS", line 818
> ORA-06512: at line 1
>
> Any ideas ?
Never mid ... This error occurs when the tablespace name specified is
invalid. It was actually INDX instead of INDEX.
Received on Fri Jun 08 2007 - 00:41:04 CDT
