Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the structure of some tables

Re: How to get the structure of some tables

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 13 Nov 2003 15:36:30 GMT
Message-ID: <3FB3A4FE.D5B77C0E@remove_spam.peasland.com>


You have a couple of options.

  1. Use export (with ROWS=N) to capture the DDL statements. On the dump file, run import with either SHOW=Y and log the output to a file, or with INDEXFILE (probably the preferred option). You can then edit the DDL file and use this as a script in your Oracle 8 database.
  2. Use 9i's DBMS_METADATA package to extract the DDL statements. Save the output in a script to be run in your Oracle 8 database.
  3. Use 9i's Oracle Enterprise Manager. Right click on the table and choose SHOW SQL. This will be the DDL statement to recreate the table.
  4. Use 3rd party tools like Toad.

HTH,
Brian

Karim Bernardet wrote:
>
> Hello,
>
> I have to modify some tables from an oracle 9 database. So I would like to
> export the structure of those tables to recreate them on a development database
> (oracle 8). So how can I do that ?
>
> Thanks for your help
>
> Karim.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Thu Nov 13 2003 - 09:36:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US