ERROR at line 1

hi can you solve this problem.....
SQL> create TABLE test (name varchar2(30));
create TABLE test (name varchar2(30))
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access

Views: 596

▶ Reply to This

Replies to This Discussion

Permalink Reply by Toni Gros on November 11, 2014 at 3:17pm

you can't create any object on standby side(read only) mode(in your case) try to create the table on primary database and it will reflect in standby database.

Permalink Reply by Maryln Kiss on November 11, 2014 at 3:17pm

then how to create object on read only mode

Permalink Reply by Rona Wafford on November 11, 2014 at 3:18pm

u can only fire select statement on standby database. u cant able to create any objects

Permalink Reply by Maryln Kiss on November 11, 2014 at 3:20pm

okay thank u Rona

▶ Reply to Discussion

RSS

Oracle Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service