| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tablespaces ddl extract script
SELECT DBMS_METADATA.GET_DDL('TABLESPACE',a.tablespace_name) FROM dba_tablespaces a
/
Will give you all of them.
Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
717-783-8095 Ext 337
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of The Human Fly
Sent: Wednesday, October 12, 2005 6:24 AM
To: Oracle-L Freelists
Subject: tablespaces ddl extract script
Friends,
My mgmt. has decided to move our datawarehouse, around 1.5 TB from AIX
server to HP-SUPERDOM. We are using oracle 9i and only export and
import possible, I believe. This database has around 100 tbs. My
planning is to get ddl of those tablespace exists on AIX to create
them on HP-SUPERDOM server database.
Can any has scripts to extract the ddl of all tablespace with datafile
defination in a database?
Thanking you in advance.
--
Best Regards,
Syed Jaffar Hussain
 |
 |