stored procedure to transfer data from a table in one database to a table in another database in ora

Posted by ranju on Stack Overflow See other posts from Stack Overflow or by ranju
Published on 2009-10-26T02:51:35Z Indexed on 2010/04/19 8:03 UTC
Read the original article Hit count: 203

Filed under:

oracle9i

there are 2 databases A AND B. i want to transfer data from a table in A TO a table in B. i want to use cursor for this. the duplicate datas when transferring should go to a table called duplicat table. I want a stored procedure to do the above. first i need to connect database A with database B using db link. i want the complete stored procedure. can anyone help plzzzzzzzzzz...........

Related posts about oracle9i

Oracle9i export error

as seen on Server Fault - Search for 'Server Fault'
When I rut the following: set ORACLE_SID=orcl exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp in the end i see the following: EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully what should i do to resolve… >>> More
migrating from mysql to oracle9i.Equivalent create table syntax

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Following is the syntax for creating table in mysql. I want to create table with same properties in oracle9i. Can anyone provide me the equivalent syntax for oracle? CREATE TABLE IF NOT EXISTS "tbl_audit_trail" ( "id" int(11) unsigned NOT NULL, "old_value" text NOT NULL, … >>> More
how query a cube olap using a java Application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I've a cube olap created with oracle9i, and I want to do some queries on this cube using a java application, but the problem is: how can I connect the java application with the cube olap. thanks for your help >>> More
Oracle 9i Session Disconnections

as seen on Server Fault - Search for 'Server Fault'
I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful connections. We got this box set up by our IT department and handed over to. It is 'our problem', so options… >>> More
Linked SQL Server to Oracle

as seen on Server Fault - Search for 'Server Fault'
Getting this error when executing SQL Server query only when connected via remote Desktop. When running the query from desktop, no problem. Is this a tsnNames issue? Linked server to Oracle 9i Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider… >>> More

Developer IT

stored procedure to transfer data from a table in one database to a table in another database in ora - Developer IT

stored procedure to transfer data from a table in one database to a table in another database in ora

oracle9i

Related posts about oracle9i

Oracle9i export error

migrating from mysql to oracle9i.Equivalent create table syntax

how query a cube olap using a java Application

Oracle 9i Session Disconnections

Linked SQL Server to Oracle

Categories cloud