Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Extract Object's DDL & Storage definitions from the Database

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

From: <>
Date: Tue, 10 Oct 2006 16:00:56 +0200
Message-ID: <>

Wouldn't dbms_metadata be so much more useful if it provided full schema details with one command rather than having to run metadata commands to get tables, views, indexes, etc etc and then hoping you have not missed anything.
I am sure that situation has not changed with 10G but I would be happy to be that I am wrong


EDS - EMEA Integration Engineering / ABN AMRO Account Location: Floor 3 Paalbergweg

Desk Phone +31 (0) 203434075

"Pande, Rajendra" <> Sent by:
10/10/2006 03:43 PM
Please respond to

To, cc

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: [] On Behalf Of VIVEK_SHARMA
Sent: Tuesday, October 10, 2006 8:33 AM
Subject: Extract Object's DDL & Storage definitions from the Database  


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  

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.

This message (including any attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. ABN AMRO Bank N.V, which has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587, including its group companies, shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference.

-- Received on Tue Oct 10 2006 - 09:00:56 CDT

Original text of this message