WELCOME ON BOARD - ORACLE
Monday, November 17, 2008
Error:
Error (ORACLE-25153): ORA-25153:
Temporary Tablespace is Empty
Solution:
alter tablespace temp add tempfile '/u01/app/oradata/temp01.dbf' size 500m;
Thursday, August 7, 2008
DBVERIFY Error: DBV-00103: Specified BLOCKSIZE (2048) differs from actual (16384)
Error:
DBV-00103: Specified BLOCKSIZE (2048) differs from actual (16384)
Solution:
Instead of using,
$ dbv file=
datafilenamestart=1 end=500 logfile=dbverify.log
use the below
$dbv file=
datafilename blocksize=db_block_size
Thursday, July 17, 2008
ALTER SYSTEM SWITCH LOGFILE Statement hangs
ALTER SYSTEM SWITCH LOGFILE hangs:
Step 1: Login as sysdba.
Step 2: Enable log_archive_dest_state_1 Parameter.
SQL>alter system set log_archive_dest_state_1=enable scope=spfile;
System altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
Newer Posts
Home
Subscribe to:
Posts (Atom)