OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » LMT error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LMT error [message #179978]

Thu, 29 June 2006 09:46

tedd
Messages: 13
Registered: June 2006

Junior Member

i get this error when i try to convert ti lmt

i used the package

error msg follows
SQL> select tablespace_name,contents,extent_management from dba_tablespaces;

TABLESPACE_NAME CONTENTS EXTENT_MAN
------------------------------ --------- ----------
SYSTEM PERMANENT DICTIONARY
UNDOTBS UNDO LOCAL
CWMLITE PERMANENT LOCAL
DRSYS PERMANENT LOCAL
EXAMPLE PERMANENT LOCAL
INDX PERMANENT LOCAL
TEMP TEMPORARY LOCAL
TOOLS PERMANENT LOCAL
USERS PERMANENT LOCAL
ALLUSER PERMANENT LOCAL
TOOLS1 PERMANENT DICTIONARY

11 rows selected.

SQL> exec dbms_space_admin.tablespace_migrate_from_local('tools1');
BEGIN dbms_space_admin.tablespace_migrate_from_local('tools1'); END;

*
ERROR at line 1:
ORA-00959: tablespace 'tools1' does not exist
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1

SQL> exec dbms_space_admin.tablespace_migrate_to_local('tools1');
BEGIN dbms_space_admin.tablespace_migrate_to_local('tools1'); END;

*
ERROR at line 1:
ORA-00959: tablespace 'tools1' does not exist
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1

SQL> exec dbms_space_admin.tablespace_migrate_from_local('example');
BEGIN dbms_space_admin.tablespace_migrate_from_local('example'); END;

*
ERROR at line 1:
ORA-00959: tablespace 'example' does not exist
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1

Report message to a moderator