Exporting a database table:
- Start navigator.
- Expand personal Oracle (click on the +)
- Select local database and expand it (click on the +)
- Select projects
- Go to File/New/New Project - name and save the project (I saved in in a folder I set up
on the C drive)
- Close the project window that comes up
- Expand projects and you will see the name of the new project you just created
- Select tables (the table list will now appear in the right window)
- Select the table you want to export and copy and paste it into the project folder you
just created (select the table, copy, select the project folder, paste) - you will now see
the table you want to export in the list on the right
- Right click on the project and select Export
- Select the A drive (if that is where you are exporting to) and click Save
- Should get a message that export was successful
- On the a drive you should see two files with your project name and the extensions .dmp
and .log
To import to another computer:
- Bring up navigator on other computer.
- Click on personal Oracle
- Click on local database
- Right click on local database/select import/select A drive and open .dmp of project you
exported.
- Should get a message that says import was successful.
- Click on view in the menu at the top and click on refresh
- Expand the local database and click on table - the table will be in the list in the
right window.