Options to transfer data [message #72462] |
Tue, 24 June 2003 03:10 |
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 |
|
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
|
|
|