Re: Retreive data between schemas

Hi Jeroen:

Thank you very much for your reply.

Yes, I forgot to mention that the project I am working on is still under development. All the table anme, table columns, and database instance name have not been finialized yet. But I need to do the coding. That's why I want NOT to hard-code teh database link in my program, just in case of changes.

The data I need to access are in different schema and in different database.

Best regards,

Jeroen van Sluisdam (Jeroen.van.Sluisdam_at_vrijuit.nl) wrote:
: Hi

: - if those schemas are in the same database just use schemaname.tablename
: Condition is that you have
: select rights for those tables
: - if it has to run regularly use a database link, create the thing outside
: you're program and use
: linkname.table_name
: - if it has to run once use exp, imp table to a certain user or not

: Jeroen

: suisum_at_freenet.edmonton.ab.ca wrote:

: > From suisum_at_freenet.edmonton.ab.ca Sat Sep 12 05:38:45 1998
: > Date: Wed, 9 Sep 1998 22:30:10 -0600 (MDT)
: > From: Still Water <suisum_at_freenet.edmonton.ab.ca>
: > To: Oracle dba <oracledba_at_MailingList.net>
: > Subject: Retreive data between schemas
: >
: > Hi:
: >
: > If I need to retrieve data from serveral schemas, what will be the best
: > way to do it?
: >
: > . to use database link.
: > But I don't know how to do that in a stored procedure.
: > I don't know how to avoid hard-code the database link in the program.
: >
: > . to create temporary tables and use SQLLDR.
: >
: > . to do export and import.
: >
: > --
: > Best regards,

--
Best regards, Received on Sat Sep 12 1998 - 12:33:43 CDT