ORA-12345: user string lacks CREATE SESSION privilege in
database link (linkname string)



ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)..

Answer / guest

Cause: There are several possible causes for this message:
First, you will get this message if your username in the
second database specified was not granted the CREATE SESSION
system privilege. Second, you will get this message if the
username specified in the connect string of the database
link definition was not granted the CREATE SESSION system
privilege.

Action: The action you take depends upon the cause of the
message: In the first case, ensure that your username in the
secondary database was granted the CREATE SESSION system
privilege. In the second case, ensure the username specified
in the connect string of the database link definition was
granted the CREATE SESSION system privilege in the secondary
database.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00804: SEQUENCES with intervals are not supported by External Table Load.

1 Answers  


PCC-02328: undefined struct member

1 Answers  


ORA-25275: Test support for buffered queues

1 Answers  


IMG-00511: %s

1 Answers  


SQL-02149: ANSI Dynamic insufficient item descriptor areas

1 Answers  


ORA-14061: data type or length of an index partitioning column may not be changed

1 Answers  


KUP-04003: error while closing file string

1 Answers  


TNS-04005: Unable to resolve address for string.

1 Answers  


ORA-12854: Parallel query is not supported on temporary LOBs

1 Answers  


DGM-16959: NULL answer from DMON

1 Answers  


ORA-01223: RESETLOGS must be specified to set a new database name

1 Answers  


ORA-27452: %s is an invalid name for a database object.

1 Answers  


Categories