Skip to Main Content
Oracle Data Guard 11gR2 Administration : Beginner's Guide
book

Oracle Data Guard 11gR2 Administration : Beginner's Guide

by Yunus Emre Baransel, Nassyam Basha
June 2013
Beginner content levelBeginner
404 pages
9h 40m
English
Packt Publishing
Content preview from Oracle Data Guard 11gR2 Administration : Beginner's Guide

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. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database Administration: The Essential Refe

Oracle Database Administration: The Essential Refe

David C. Kreines, Brian Laskey
Oracle Database 12c Security

Oracle Database 12c Security

Scott Gaetjen, David Knox, William Maroulis

Publisher Resources

ISBN: 9781849687904Other