Database links are always slow on Monday.
Try it again tomorrow.
--
"Maria" <evoradba_at_yahoo.ca> wrote in message
news:351fd9d6.0401191700.68f782ab_at_posting.google.com...
> Hi all
>
> I have recently configured a Oracle database server 8.1.7.4.0 on
> Solaris 5.8. I have created 2 instances each with 1 schema then I
> have created links to copy data across, then creates the indexes
> locally on the schema, the entire process is taking 2 hours, mean
> while I have 1 server with only 1 instance which has 2 schemas and the
> same process takes about 1 hour. The server configuration is the
> same the database configuration is the same and data as well, I even
> did a remote "create table as select * from ..." in between all
> instances and its all the same time expect when I came into the ONLY
> one instance and 2 schemas? can be that a distributed database link is
> taking double time to create table as select?
> Does any one came across this before? I called oracle support and they
> say yes its the link, I just can't believe that this can be double of
> time... Any ideas would be greatly appreciated
>
> Regards
> Maria
Received on Tue Jan 20 2004 - 00:41:42 CST
