Home » RDBMS Server » Server Administration » Unable to extract ddl of tablespace (Oracle 10.2.0.4.0,windows)
Unable to extract ddl of tablespace [message #544825] Fri, 24 February 2012 02:59 Go to next message
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,



Re: Unable to extract ddl of tablespace [message #544828 is a reply to message #544825] Fri, 24 February 2012 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Your user has not the appropriate privileges to extract the definition of a tablespace.

Regards
Michel
Re: Unable to extract ddl of tablespace [message #544833 is a reply to message #544828] Fri, 24 February 2012 03:28 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Ok.What privileges are required for a user to extract the definition of a tablespace ?

Thanks

[Updated on: Fri, 24 February 2012 03:36]

Report message to a moderator

Re: Unable to extract ddl of tablespace [message #544837 is a reply to message #544833] Fri, 24 February 2012 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Something like EXP_FULL_DATABASE but I bet this is somewhere in the documentation.

Regards
Michel
Re: Unable to extract ddl of tablespace [message #544846 is a reply to message #544837] Fri, 24 February 2012 04:37 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Ok.Thank you for your answers.
Previous Topic: user transfer
Next Topic: How to change the character set ?
Goto Forum:
  


Current Time: Sun Dec 01 14:22:53 CST 2024