CODEWITHSUNDEEP
databaseoracle-databaseubuntuexport
user1994660
user1994660

Reputation: 5593

How can I export oracle database remotely?

I have been given oracle database credentilas as read/write only user.

Now for my experimenting stuff I want to export the data from oracle server to local VM.

I tried copy and inserting tables into postgres using pentaho but that failed.

Is there any way I can export that oracle data and insert in locally?

Can I install some free oracle on ubuntu and then I can do something to get that data?

I don't know oracle much

Upvotes: 0

Views: 3615

Answers (2)

user3346850
user3346850

Reputation: 363

Use Oracle Data Pump. That is the full documentation for Oracle 10 Data Pump. Also you can find the documentation for 11g here and here.

impdp and expdp work as command line. You can invoke them directly from the server or from a machine that has Oracle client installed and a connection to the server.

Considering you have limited rights on the server you will not be able to do a full database export, but I guess you do not need to; you only need to export your working schema/tables. The documentation shows how to do that: use expdp export only a schema and/or only some objects.

Once the export is done, you can copy the dmp file to any other computer (including a VM) and use impdp to import all the data to another Oracle database. You need to set up the new database before the import (import does not create it for you).

Upvotes: 0

grizzly
grizzly

Reputation: 1156

There are certainly more sophisticated ways of how to export database or a table on Oracle, but I usually export and copy the dbs with the help of Oracle SqlDeveloper. Just go to Tools menu and then select Database Export or Database Copy. Just remember that this is not the full db expot, ie. the users are not usually copied with this procedure.

The good thing is, that you may connect this tool to any database server that has Java Connector, and that makes it easy to export the data into an SQL Sever or Postgres.

If you want a more sophisticated way to export the data, check out the Recovery Manager (RMAN) and the DUPLICATE command documentation here: RMAN on Oracle

Upvotes: 2

Related Questions