SQL>
SQL> CREATE TABLE source_log
2 (backup_date DATE,
3 backup_time VARCHAR2(6),
4 last_ddl_time DATE,
5 owner VARCHAR2(30),
6 name VARCHAR2(30),
7 type VARCHAR2(12),
8 line NUMBER,
9 text VARCHAR2(2000))
10 /
Table created.
SQL> CREATE INDEX source_log_idx1 ON source_log
2 (last_ddl_time, owner, name)
3 /
Index created.
SQL> CREATE or replace PUBLIC SYNONYM source_log FOR source_log
2 /
Synonym created.
SQL> GRANT SELECT, INSERT ON source_log to PUBLIC
2 /
Grant succeeded.
SQL>
SQL> drop table source_log;
Table dropped.
SQL>
SQL>
|