Can you move data from one database to another? (4289275)

Can data be moved from one database to another? There is data in one or more tables in a target database that needs to be moved over to tables in another database. Can this be done?

WORKAROUND 1:

Export to file then import that file

1. Connect to the source database
2. Go to Tool | Export | Export Wizard
3. Export the data to a file (you can choose any file format)
4. Connect to the target database
5. Go to Tool | Import | Import Wizard
6. Import the data from the file to a table. You can either choose an existing table or choose to create a "single new" table on the fly
(Keep in mind that TDA defaults to basic datatypes and there's not way to specify it on the fly.)
 

WORKAROUND 2:

Use the Tools | Import | Import Wizard directly.

1. Connect to your Oracle database
2. Go to Tool | Import | Import Wizard
3. Click "Add Query"
4. Select the Access connection in the drop down and type in the query that will return the data you wish to import from Access
(You can click on “Preview Result” to test your query and review the data coming into Oracle from Access.)
5. Click next in the wizard... you can either choose and existing table in Oracle, or choose to create a "single new" table on the fly
(Again keep in mind that TDA defaults to basic datatypes and there's not way to specify it on the fly.)
6. Continue throught the wizard till "finish"