Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: New to Oracle
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