Database Administration (MOSC)

MOSC Banner

Temp tablespace in 9i

edited Apr 11, 2012 4:24AM in Database Administration (MOSC) 5 commentsAnswered
Hi all,

   My db is 9.2.0.4 64 bit on AIX.

   With a command to create temporary tablespace such:

   CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
   '/oradata/bankpri/temp01.dbf' SIZE 100M AUTOEXTEND OFF
   EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

   And DBA that just leave this position said that it's temp default in oracle 9i. And I'm going to recreate a new temp with:

  CREATE TEMPORARY TABLESPACE TEMP
  TEMPFILE '/oradata/bankpri/temp01.dbf' SIZE 100M
  AUTOEXTEND ON NEXT 20M MAXSIZE unlimited
  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

   I think that it should autoextend !

   Have any ideas ?

   Thanks

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