› Fóruns › Banco de dados Oracle › Invalid object › Invalid object
4 de dezembro de 2009 às 5:35 pm
#91355
burgaParticipante
O nome dos dblinks são PROD.DBL1 e DESENV.DBL1
você deve usar a string inteira (Ex: @PROD.DBL1 ou @DESENV.DBL1)
Restriction on Creating Database Links
You cannot create a database link in another user’s schema, and you cannot qualify dblink with the name of a schema. Periods are permitted in names of database links, so Oracle Database interprets the entire name, such as ralph.linktosales, as the name of a database link in your schema rather than as a database link named linktosales in the schema ralph.)
fonte:
http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/statements_5005.htm