How to get all Tablespace DDLs?

I have a 10g database with 25 tablespaces. I'm trying to create one more database with similar tablespaces and with same sizings. So, i need to get all tablespace DDLs from existing database.
How can i get them?
ajaybeldeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Check out dbms_metadata.get_ddl.

Here is the list of objects you can use:
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_metada.htm#BGBIEDIA
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
0
 
sdstuberConnect With a Mentor Commented:
s elect dbms_metadata.get_ddl('TABLESPACE',tablespace_name) from dba_tablespaces
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.