Fail to append data
Hi !
i've been running a script when this error came out;
SQL> @lab_04_042_02.sql
User dropped.
User created.
Grant succeeded.
Connected.
drop table work purge
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
Connected.
System altered.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 629145600 bytes
Fixed Size 2022888 bytes
Variable Size 306184728 bytes
Database Buffers 318767104 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will load the AWR data from a dump file. ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
i've been running a script when this error came out;
SQL> @lab_04_042_02.sql
User dropped.
User created.
Grant succeeded.
Connected.
drop table work purge
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
Connected.
System altered.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 629145600 bytes
Fixed Size 2022888 bytes
Variable Size 306184728 bytes
Database Buffers 318767104 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will load the AWR data from a dump file. ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
0