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: New to Oracle

Re: New to Oracle

From: daniel <test_at_test.com>
Date: Fri, 22 Mar 2002 20:15:41 -0000
Message-ID: <a7g3af$7vr$1@news8.svr.pol.co.uk>


you could have a look at the oracle utilities manual, there you will find a chapter relating to the utility called "export" this is normally used to make a logical backup of your database objects. However you can use it with the flag;
ROWS=N
the resulting export file can be imported into a new database with the same ROWS=N setting to create a skeleton schema. You could also use the option, INDEXFILE=<filename>
this then generates an sql script to rebuild tables and indexes, but basically check the manual out,
http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76955/toc.htm or grab a copy of TOAD
http://www.quest.com/toad
this has a very nice way of createing schema scripts.

your welcome,

daniel...

"Clyde Bryant" <cbryant_at_regalwood.com> wrote in message news:oFLm8.63$f17.47065_at_news.uswest.net...
> I have a question about how I can create a schema from and already
existing
> database. I'm coming from a Informix DBA background and creating a schema
> was pretty straightforward using the "dbschema" tool from the command
line.
> Is there similar tool in the Oracle world?
>
> Thanks in advance
>
>
Received on Fri Mar 22 2002 - 14:15:41 CST

Original text of this message

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