hi,
u can use locally managed tablespace for temp.
create temporary tablespace name tempfile.will create temp as locally
managed.
if u want to create temp as dictionary manged..use
create tablespace name datafile. (as normal tablespace) then changed
to temporary using..
alter
Yes, but you have to use a temporary tablespace or TEMPFILE tablespace.
LMT is not supported on datafile tablespaces. Also note TEMPFILE has more
performance as they do not do any redo generation.
-Original Message-
Sent: Monday, May 21, 2001 1:36 PM
To: Multiple recipients of list
hi, I connect as sys/change_on_install and execute this:
create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat'
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M;
Error at line 1:
ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat'
ORA-27037: unable to obtain
hi, I connect as sys/change_on_install and execute this:
create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat'
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M;
Error at line 1:
ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat'
ORA-27037: unable to obtain
Robert,
Check your syntax.
CREATE TEMPORARY TABLESPACE c2tmp TEMPFILE
'/oracle/oradata/c2datatmp.dat'
SIZE 50M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M;
Regards,
David A. Barbour
Robert Chen wrote:
hi, I connect as sys/change_on_install and execute this:
create TEMPORARY