Re: Need help importing / exporting a schema

"Blake McBride" <blake_at_mcbride.name> wrote in news:1365runtsarg4b_at_news.supernews.com:
> I don't know what CBT is and I am not looking for complete training of
> anything.
> I did spend a bunch of time in the docs looking for the three SIMPLE
> things I
> am looking for with no luck. To-date you haven't even told me how to
> do the type of export
> I am looking for. All other databases I've ever used take one simple
> command to dump the
> entire schema to a text file. I found no reference to this anywhere
> in the docs.
> This has got to be a simple thing. I just need to know the secret
> command.

AFAIK, there is no such "secret command". You should NOT extrapolate previous experience on other DBs to Oracle. Oracle supports many more different data type than some/many/most other DBs.

Here is 1 simple example why "simple" data loading can get complicated. When a PK/FK relationship exist, the table with the PK must be loaded before the table with the FK can be loaded. Expand this to include SYNONYM, GRANT, TRIGGER & other data type it can be a non-trival operation.

>
> I am not importing the same schema that I will export. For this
> reason I need the database
> created with no tables. I've got to believe that once I've dropped
> the whole thing, one
> simple command would create the blank DB. I just need the secret
> command.

Rightly or wrongly no such SINGLE command exists for Oracle Received on Sun Jun 03 2007 - 12:05:34 CDT