This content has been marked as final. Show 2 replies
In order of efficiency,
1) If you have permission to copy the database, then the owners of the database should be able to you provide with an export file which you can import.
2) Alternatively you can install the exp utility (Part of a full oracle client install) and create your own export file.
3) You can create a database link inside your database connected to the remote database and copy tables using create table as...
4) You can use the SQL Developer BRIDGE command to access remote table. It doesn't seem to be documented directly but there some help here
For individual Oracle to Oracle table transfer there is also the copy command in Sqlplus and SQL Developer see in SQL Developer worksheet: "help copy".
Note: Data Pump is good for exporting data but you would need privileges or get your DBA to run the export - there is a wizard in the DBA view for both the export and import.