Re: overwrite schema.table name

-why not create a user export ( exp help=y) for schema1
-create your test schema2
-import fromuser=schema1 touser=schema2

-login to schema2 and run

• your queries/updates without modification on the test data in schema2

ofcourse if the script has hardcoded 'schema1.[etc]' you will have to edit the script first, but i'm assuming this is not the case Received on Mon Nov 07 2005 - 03:56:38 CST