Start a new topic

How can a import an exported schema again

anonymous

started a topic over 9 years ago

[This topic is migrated from our old forums. The original author name has been removed]

I am using DBVisualizer with Oracle Databases.
I can export schemas by right clicking the schema and using the export schema function
but how can I re-import an exported schema?

I am trying to use this function for exporting the schema on a remote server and re-importing the
schema to my local development system.

However, exporting seems to work, but how to import again?

Please advise.

Thanks and best

Wuppertaler

1 Comment

Hans Bergsten

said over 9 years ago

[This reply is migrated from our old forums.]

Re: How can a import an exported schema again

Hi Andreas,

If you export the schema as SQL, you can then run the script in an SQL Commander tab to import the schema.

If the script is large, you may want to use the @run command:

http://confluence.dbvis.com/display/UG92/Executing+an+External+Script

Best Regards
Hans

How can we help you today?

How can a import an exported schema again

anonymous

Hans Bergsten