Sunday, July 13, 2008

Oracle: Temp and UNDO Tablespace creation


CREATE UNDO TABLESPACE UNDOTBS01 DATAFILE
'd:\Oracle\orcldb10g\Oradata\UNDOTBS01.DBF' SIZE 300M AUTOEXTEND ON NEXT 512K MAXSIZE UNLIMITED
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;

Alter system set UNDO_tablespace = 'UNDOTBS01';


CREATE SMALLFILE TEMPORARY TABLESPACE "TEMP" TEMPFILE 'D:\ORACLE\ORCLDB10G\ORADATA\TEMP02.DBF' SIZE 100M AUTOEXTEND ON NEXT 256K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP";

1 comment:

  1. Hi-

    Your code worked excellently after I put a ';' whereever it was missing.

    I have a question: what is the default tablespace for a newly created user in Oracle?

    ReplyDelete