RE: Extract Object's DDL & Storage definitions from the Database
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'john.hallas@xxxxxxxxxxxxxx'" <john.hallas@xxxxxxxxxxxxxx>, rajendra.pande@xxxxxxx
- Date: Tue, 10 Oct 2006 16:18:33 +0100
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of john.hallas@xxxxxxxxxxxxxx
Sent: Tuesday, October 10, 2006 10:01 AM
To: rajendra.pande@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
------------------------------------------------------------------
EDS - EMEA Integration Engineering / ABN AMRO Account
Location: Floor 3 Paalbergweg
Desk Phone +31 (0) 203434075
"Pande, Rajendra" <rajendra.pande@xxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
10/10/2006 03:43 PM
Please respond to
rajendra.pande@xxxxxxx
To
VIVEK_SHARMA@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of VIVEK_SHARMA
Sent: Tuesday, October 10, 2006 8:33 AM
To: oracle-l@xxxxxxxxxxxxx
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.
---------------------------------------------------------------------------
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.
---------------------------------------------------------------------------
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
