Hi Oracle Experts,
I like to know if there's an easy way to transfer an Oracle database from our server to the Personal Oracle on my notebook. I normally make an export on the server using then EXP.EXE tool, and import the database dump in my notebook using the IMP.EXE tool. This export/import works, but I always have to delete all tables in my Personal Oracle database (using the Orcale DBA Studio) before I use the import tool. If I don't delete all tables, the import tool is displaying a lot of scrolling text while importing data. Due to this scrolling text, the import takes a very long time. When I delete all tables in the destination table first, the import is a lot faster.
In the DBA Studio on my notebook there is a menu option Export, Import, Backup and Recovery, but all these menu's generate an error message "This wizard can only be launched when the application is connected to the Oracle Management Server"....?
So, my question is: is there a way to import a database dump without deleting all tables in the destination database first, and without waiting a long time for the many text lines scrolling over the screen?
Thanks for any help!