Re: Need help importing / exporting a schema


On 3-Jun-2007, "Ana C. Dent" <anacedent@xxxxxxxxxxx> wrote:

"Blake McBride" <blake@xxxxxxxxxxxx> wrote in
news:1365runtsarg4b@xxxxxxxxxxxxxxxxxx:
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.



The dump would contain all the create table commands first, then the
primary keys, indexes, foreign keys, etc. Done in this order there is
no problem with dependencies. Also, if a database only contains
string and numeric columns then exporting and importing in text based
SQL commands works fine. The main reason I can see why Oracle won't
provide text SQL schemas is to make it maximally difficult to change
databases.

Without a schema dump I can't keep an Oracle schema in sync with a
postgres schema. I have my own program to do this (works with MSSQL &
Postgres) but depends on a textual SQL schema file. This presents a
significant problem for me.

Blake McBride
.

Relevant Pages

  • Change default Schema for a user automatically
    ... Is there a way that I define, default Schema for a user automatically? ... I have some users that login from different software and they have no data ... command for user to make it run whenever it login to system? ... I use Oracle 10G release 2.0 under widows Server 2003, ...
    (comp.databases.oracle.server)
  • Re: Drop database on Oracle 9i
    ... How can I drop my database? ... EVERYTHING - the entire Oracle instance. ... I believe the command is drop schema. ...
    (comp.databases.oracle.server)
  • Re: ADPrep /forestprep failed 2000 to 2003 r2
    ... Additional post the output from "schupgr" from the command prompt on the 2000 DC. ... Disclaimer: This posting is provided "AS IS" with no warranties, ... So which adprep version from the R2 disk do you run, ... Click Active Directory Schema, ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADPrep /forestprep failed 2000 to 2003 r2
    ... Here is the output of the "schupgr" command. ... Upgrading schema to version 31 ... So which adprep version from the R2 disk do you run, ... "Active Directory Schema" is displayed in the Add/Remove ...
    (microsoft.public.windows.server.active_directory)
  • Re: ODBC cannot access Oracle tables under different schemas in one session
    ... >Access / Oracle problem, ... >referring to the proper server / SID of every branch. ... >table, when i try to query the second table under another schema, ODBC ... >shift to another schema and query their tables, ...
    (comp.databases.oracle.misc)