O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – creating objects on the logical standby database

Now let's try to create some objects on the logical standby database. First we will create a test table with the HR user. The Database Guard mode is ALL, which is the default.

  1. Connect the logical standby database with SYS user and execute the following query:
    SQL> SELECT GUARD_STATUS FROM V$DATABASE;
    
    GUARD_S
    -------
    ALL
    
    SQL> CONN SCOTT/TIGER
    Connected.
    SQL> CREATE TABLE TEST (A NUMBER);
    create table test (a number)
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges

    The error message specifies a privilege problem but this is not due to the lack of create table privilege for the HR user. We receive this error because the Database Guard mode does not allow for creation of the table. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required