Database Tuning (MOSC)

MOSC Banner

Fail to append data

edited Jun 27, 2013 5:10PM in Database Tuning (MOSC) 3 commentsAnswered
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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center