maybe u can try this one : create database link "name of db link" connect to username identified by "<pwd>" using 'connect string'; (using script execute by toad or sql plus)
don't forget to update the tnsname.ora file and add the db info that u want to link... for more details u can see this link (db 10g): http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5005.htm Regards, ardyani - cmiiw be positive in everything that may come to you... ____________________________________________________________________________________ Get easy, one-click access to your favorites. Make Yahoo! your homepage. http://www.yahoo.com/r/hs
