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.
- Connect the logical standby database with
SYSuser 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 tableprivilege for the
HRuser. We receive this error because the Database Guard mode does not allow for creation of the table. ...