| Database Mapping? [message #62345] |
Thu, 15 July 2004 21:58  |
JoinNepal
Messages: 33
Registered: October 2003
|
Member |
|
|
Hi,
I have two databases A and B.
Database A contains my main information and tables. Database also contains some tables... Now, I want to access or retreive or save the data into the tables in the Database B since I am always logged on to Dataabase A.
How can I do so?? Please let me know and help me.
Yours,
Joinnepal
|
|
|
|
| Re: Database Mapping? [message #62348 is a reply to message #62345] |
Fri, 16 July 2004 01:54  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Here are a couple of methods to do it:
1. Create a database link from B to A and use it to query the data from A.
2. Export tables on A and import on B
3. Use the sqlplus COPY command to copy the data from A to B.
Best regards.
Frank
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
