sqlquery format

I want to know the sql query  for my  usertablespace creation..

Is there any way for that?
tonydbaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Wasim Akram ShaikConnect With a Mentor Commented:
Yes you can refer to this link for full details, just placing the syntax for your reference though

select dbms_metadata.get_ddl('TABLESPACE',tablespace_name) from dba_tablespaces;


http://www.dba-oracle.com/t_1_dbms_metadata.htm
0
 
DavidSenior Oracle Database AdministratorCommented:
I recommend in your SQL session, prior to the SELECT command above:

SET LINESIZE 0                          NOTE  no semicolon nor /
0
 
Wasim Akram ShaikCommented:
-->>I recommend in your SQL session, prior to the SELECT command above:

This is needed only if your are using sql*plus , if you are using any other tool, such as toad or sql developer, this is not needed..
0
 
tonydbaAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.