• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

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?
0
ajaybelde
Asked:
ajaybelde
  • 2
3 Solutions
 
slightwv (䄆 Netminder) 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) Commented:
0
 
sdstuberCommented:
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now