Clarification please

[ScottMattes]

For Export/Import tables using the PLSD tab, will the import do the import to the schema that the export was done to, or will it use the schema that I am connected to?

I want to copy some tables from our application schema into my schema to run some tests, but I have no idea what the Import is going to try and do - and this is not one of those times I would advocate 'try it and see'.

Thank you.

 

[Marco Kalter]

To export tables and import them into a different schema, you must:

• Connect as the user that owns the tables
• Export the tables
• Connect as the user that will own the tables
• Import the tables

The name of the owner will not be included in the export file if you are connected as that owner during export.