http data transfer between two Oracle database

[Ricky]

please let me know,how can i do a data transfer between two oracle database,when i have only very limited privilege on other database server(say only read priviliege).

Thanks

[Halo]

Data transfer can be done using:
1. copy command using db link
2. ftp

[sree_sri]

The Bestway to copy data between data from one database to another database is based on the size of the data.

For ex:

If you want to copy the data from one table to another and the data size is not more then you can copy data by using
copy command and db link.

But if data is more then do export/import.

In your subject you mentioned HTTP transfer, I did't understand that question? If you give me some more details on your job i can giveyou the complete steps. Good Luck.

[Ricky]

When you say copy.. do you mean....

create table as select ... from using database link

please let me know..

[Ricky]

I have only select privilege...

So please let me know the options that are avaible for a database user who have only select privilege..

then i think, i can't use the export/import option.. and data is pretty big.. like 3 million records..

[Halo]

For a table of that size, the best thing to do is to export the table, compress the file and ftp it to target server.

[sambavan]

I second the Halo's suggestion. That is the best and fast way to get things going.


Sam

[Ricky]

Hii Halo and sri,
I am sorry !!.I forget to mention one thing..... I don't get any export file from that remote database....

we only have select privileges to some of the table we need....

SO what you thing..... whether i can implement..... create table.... as select.... or that's not good for a 2 million record or more.. ... please let me know the option.....

[Halo]

Create table as select ... using a db link would work, but will take a long time. Have the DBA export/import the table. If you have a db link between the 2 databases, then use the copy command to copy the table across, in the following manner:
1. login as the user in the target db
2. precreate the table
3. (copy command syntax)
set copycommit 1;
set arraysize 1000;
copy -
from username1/password1@source_db -
to username2/password2@target_db -
insert target_table_name using -
select * from source_table_name

[sree_sri]

Ricky,
I am with Halo, If you are not able to export/import then try with copy command. With compare to create table as select ,COPY command is faster. For this you don't need to create a db link also. Just it will see the database name in your tnsnames.ora. So Good Luck.