Re: export/import

export full=y rows=n compress=n

import into other database as a full import

alter table big_table storage(maxextents 1);

exp full=y rows=y

imp full=y commit=y ignore=y

You will get an error on the big table about not being able to extent it. (so what)

when done truncate/drop what was placed in big table.

Note there are parameters for this process that are left out.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Dominik Schroeder" <dschroeder_at_gei-aachen.de> wrote in message
news:3919487C.7FEF0DB_at_gei-aachen.de...


> Hi all!

>

> the database:

> one user (next to standard users) w/ around 1000 tables.

> all tables are rather small.  many triggers and constraints tangle them

> together.

> one table VERY big.  it is located in an extra table space within an

> extra database file.  no triggers  or constraint apply to this big

> beauty.

> several stored procedures exist (wrapped, no source code available).

>

> my problem:

> i need to copy this database, except the big beauty!

>

> first tries:

> copy of database files, except the big beauty file. => new database was

> corrupted.

>

> make list of tables and ordering it in regard to the constraints.

> removing big beauty from list.

> exporting (via exp) all those tables.

> dropping all those tables in reverse order from the other database.

> importing the previously exported tables.

> => didn't lead to a perfect database.  i suppose, that there are more

> things to pay attention to, than the constraints, when ordering the list

> of tables.

>

> questions:

> is it possible to export like "exp TABLES=(all, except big_beauty)"?

> is it possible to export on basis of database files?

> is it possible to export on basis of table spaces?

> how can i delete all tables of a user, w/o also deleting its stored

> procedures?

>

> i know, this is a lot...but i have to find a way how to get all data

> except the big beauty from one database into another......

>

> thanx for ready, even more thanx for answers, whatsoever... :-)

>

> dominik

>

> e-mail: schroeder.dominik_at_gmx.de