Home » RDBMS Server » Server Utilities » Options to transfer data
Options to transfer data [message #72462] Tue, 24 June 2003 03:10 Go to next message
mbeek
Messages: 2
Registered: June 2003
Junior Member
We are setting up a process to extract data from a source database to a staging database. There are a number of options available to do this in Oracle, but in our situation we don't have access to a DBA account, nor the full import and export roles (violates company security policy).

One option which still remains is to spool/utl_file and use SQL*loader, but this is considerably slower than the import/export option.

Are there any others I am missing which do offer good performance?

Many thanks
Re: Options to transfer data [message #72464 is a reply to message #72462] Tue, 24 June 2003 05:56 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can always export / import the objects owned by u.
If You are looking into a full database export or export other users data, You need dba rights.

You can create a database link in the target.
and copy/extract the tables 
something like ( in the target)

----------------------------------------------------------------------

create database linke sourcedb_tnsname
connect to scott identified by tiger
using 'sourcedb_tnsname';
-- now create a full table or extract certain columns
-- or use where conditions to create your new tables
-- from the source tables over the databaselink

create table local_emp select * from emp@sourcedb_tnsname;

[Updated on: Fri, 30 July 2010 09:34]

Report message to a moderator

Previous Topic: Urgent -- Import/Export
Next Topic: Wrap utility and DOS style end of lines
Goto Forum:
  


Current Time: Tue Dec 24 07:47:10 CST 2024