Unable to extract ddl of tablespace [message #544825] |
Fri, 24 February 2012 02:59 |
|
Jack14
Messages: 497 Registered: December 2011 Location: INDIA
|
Senior Member |
|
|
[code]SQL> set heading off
SQL> set pagesize 0
SQL> set long 1000000
SQL> set feedback off
SQL> select
2 dbms_metadata.get_ddl('TABLESPACE','TBLS_DATA')
3 from
4 dual
5 /
ERROR:
ORA-31603: object "TBLS_DATA" of type TABLESPACE not found in schema
"JACK"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2806
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
When i try to extract ddl of tablespace from a schema JACK, i get error.This tablespace TBLS_DATA
does exist in the database.
Regards,
|
|
|
|
|
|
|