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
In fact the situation has changed with 10g--you can use dbms_metadata to get DDL for what are called "heterogeneous objects"; one of them is SCHEMA_EXPORT. This package underlies Data Pump in 10g.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of john.hallas_at_nl.abnamro.com
Sent: Tuesday, October 10, 2006 10:01 AM
To: rajendra.pande_at_ubs.com
Cc: oracle-l_at_freelists.org
Subject: RE: Extract Object's DDL & Storage definitions from the Database
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
John
Desk Phone +31 (0) 203434075
"Pande, Rajendra" <rajendra.pande_at_ubs.com> Sent by: oracle-l-bounce_at_freelists.org
10/10/2006 03:43 PM
Please respond to
rajendra.pande_at_ubs.com
To
VIVEK_SHARMA_at_infosys.com, oracle-l_at_freelists.org
cc
Subject
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
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.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 10 2006 - 10:18:33 CDT