Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to activate a database link?

286128Jun 3 2002
How can one activate a database link w/in SQL*Plus or DBA Studio?

I'm trying to re-create my schema in a new instance and in order to execute my materialized view SQL I must first create a new database link. I'm using the same info as in our other instance so am sure the connection will work IF I can get the database link to be 'active'. I created the link in DBA Studio and attempted to test, but received the error "Database link is not active." Canned it and created through SQL*Plus with same result. I see no option to activate and cannot find any info in 8i DBA Handbook or 8i DBA Bible.

Only way to create an active dblink is to find another link that is already active and do a Create Like.

I figure there's an easy solution to this problem, but cannot figure out what it is. Any help is appreciated!

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2002
Added on Jun 3 2002
1 comment
836 views