-
DB Links from Readonly databases.
Hi,
I have this issue with DB links from a readonly standby database.
tried to select from another DB through a link,but it errors with the follwoing message:
ERROR at line 5:
ORA-00372: file 1 cannot be modified at this time
ORA-01110: data file 1: '/exxx_dataxxx/xxxx/system_01.dbf'
This is a 8.1.7.4.0 database.
The same happens with a 10G R1 instance as well,but the error message is :
ERROR at line 1:
ORA-16000: database open for read-only access
I have verified that the links are created properly.
Is it true that we cant query a remote DB from a readonly DB using DB links?
What could the errors mean?
Thanks in advance.
Ranjini.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|