Vivek,
Try:
Set head off
Set lines 1000
Set pages 4000
Set trimspool on
Set long 4000
Spool ddl.sql
select dbms_metadata.get_ddl('TABLE',table_name) from user_tables;
Tom
This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
Sent: Tuesday, October 10, 2006 8:33 AM
To: oracle-l_at_freelists.org
Subject: Extract Object's DDL & Storage definitions from the Database
Folks
For certain Partitioned Tables & respective partitioned indexes, need to
extract from the database the respective DDL script, Storage definition
(initial, next extent sizes etc), partition key, respective Tablespace
names containing the different Table/index partitions
Is there some easy-way/script to do this? OR do we need to Query
multiple views - dba_segments, dba_tab_partitions, dba_ind_partitions
etc
Thanks indeed
- CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 10 2006 - 08:58:32 CDT
