export/import

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 Received on Wed May 10 2000 - 00:00:00 CDT