Re: Retreive data between schemas

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,
Received on Sat Sep 12 1998 - 08:27:17 CDT