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

Home -> Community -> Usenet -> c.d.o.misc -> Re: show create table in oracle?

Re: show create table in oracle?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 21 Jan 2004 17:54:38 +0100
Message-ID: <400eae5b$0$1150$636a55ce@news.free.fr>

> "feo_at_soy.madre" <paslical_2000-QUITAESTO_at_yahoo.es> a écrit dans le message de
news:bum5h1$j488h$1_at_ID-66131.news.uni-berlin.de...
> oracle 8i. I need a sentence to replicate in others databases.

> thanks.

You can use export/import utilities to do that.

exp ... tables=(<table list>) rows=n

then at the target database:

imp ... full=y

Have a look at:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/toc.htm for all the parameters.

BTW, all the docs are on tahiti: http://tahiti.oracle.com/

Regards
Michel Cadot Received on Wed Jan 21 2004 - 10:54:38 CST

Original text of this message

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