RE: Extract Object's DDL & Storage definitions from the Database

Assuming 9I+ database use DBMS_METADATA  

Rajendra Pande

1000 Lincoln harbor

ITI Infrastructure

Ph - 201 352 1415 (19 422 1415)

Pager - 1 201 718 0176

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***

Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

UBS Financial Services Inc.
UBS International Inc.

--
http://www.freelists.org/webpage/oracle-l