Dblink create normally, but the query database other times
ORA - 00942: a table or view does not exist
ORA - 02063: before the line, since linkfroma


But there must be another library users this list


What to do

CodePudding user response:

The query and the query results are coming,

Create dblink statement also coming

Each other query statements and results of this form, is also coming

CodePudding user response:

reference 1st floor selling fruit net reply:

query and the query results are coming,

Create dblink statement also coming

Each other query statements and result of this table, also coming

CREATE public DATABASE LINK G3_CXK CONNECT TO DC_CX IDENTIFIED BY "NkA * h5M ~ sA"
USING '(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=143.12.64.135) (1521) PORT=)
(ADDRESS=(TCP) PROTOCOL=(HOST=143.12.64.136) (1521) PORT=)
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SERVICE_NAME=ahdsdc)
)
) ';

CodePudding user response:

Select * from dba_db_links;

Check it and see whether there is the name of the same dblink

CodePudding user response:

reference 3 floor selling fruit net reply:

select * from dba_db_links;

Check and see whether there is the name of the same dblink

Definitely not!

CodePudding user response:

Other not available in the table?

CodePudding user response:

Did you authorized?

CodePudding user response:

reference 5 floor select_update_insert reply:

other not available in the table?

The DC_CX under all the tables are not dblink queries

CodePudding user response:

refer to 6th floor to swim 灬 soul response:

did you authorized?

How to authorize?

CodePudding user response:

https://www.cnblogs.com/Jace06/p/8549217.html

CodePudding user response:

refer to the eighth floor weixin_40432088 response:

Quote: refer to the sixth floor swim 灬 soul response:

Did you authorized?

How to authorize?

is to empower you to use the user to grant select on the table to the user

CodePudding user response:

references to the tenth floor swim 灬 soul response:

Quote: refer to the eighth floor weixin_40432088 response:

Quote: refer to the sixth floor swim 灬 soul response:

Did you authorized?

How to authorize?

is to empower you to use the user to grant select on the table to user

A library of A user to create A dblink B to B library users, now want me to B user query table under permission is assigned to A??????? Seems to be no good