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";
Hi-
ReplyDeleteYour 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?