...
| No Format |
|---|
ALTER USER oe IDENTIFIED BY oe;
ALTER USER oe ACCOUNT UNLOCK;
GRANT ALTER SESSION,
CONNECT,
CREATE MATERIALIZED VIEW,
CREATE VIEW,
QUERY REWRITE,
RESOURCE TO oe;
GRANT EXECUTE ON DBMS_LOCK TO oe;
ALTER USER OE QUOTA UNLIMITED ON USERS;
|
...
f. Drop the following table. This is part of a nested table and is not supported by the replication.
| No Format |
|---|
SQL> drop table OE.CATEGORIES_TAB; |
g. Logout of the database.
...