on 01-31-2012 9:59 AM
Dear Friends,
I have SAP ECC 6.0 , Oracle 10g on HP-UX 11iv2. Now I have another external Oracle 9i database.
I want to pull data from external database in our existing database.
Please help.
Regards
Ganesh Datt Tiwari
Hi,
Is it planned as a periodic job? Or once? You can use import/export procedure;
http://www.orafaq.com/wiki/Import_Export_FAQ
Or create a database link. Then select and insert into the table;
http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_5005.htm
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Friends,
thanks for valuable reply.
I have created a link using t. code DBCO and made entry in tnsnames.ora file in dir /sapmnt/<SID>/profile/oracle/
but when i trying to test the connection then it is giving the error as below.
Testing a Database Connection Defined in DBCON
Could not open connection MYCON .
sql error 12,154 occured:
ORA-12154: TNS:could not resolve the connect identifier specified
Regards
Ganesh Datt Tiwari
Hi Ganesh,
Below is just a guideline
Using transaction SE11, create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical.
Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE
Using SQL>
create dblink REMOTE_DB as connect to remote_user identified by password; (database link created)
drop table ZTABLE; (table dropped)
create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym created)
Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN
Enter value in key fields and hit execute. (displays rows from the remote table)
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.