Re: Why I can not create temporary tablespace?
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 tablespace name temporary. will changed it to temporary but as a dictionary managed. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, May 21, 2001 11:05 PM > David,Can we use Locally managed tablespace for TEMP? > > Thanks, > > -Original Message- > Sent: Saturday, May 19, 2001 4:55 PM > To: Multiple recipients of list ORACLE-L > > > 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 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 file status > > SVR4 Error: 2: No such file or directory > > Additional information: 3 > > > > Please tell me why? I even change the directory to 777(anyone can read and > > write) still gotta this error. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Robert Chen > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David A. Barbour > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Anne Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why I can not create temporary tablespace?
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 ORACLE-L David,Can we use Locally managed tablespace for TEMP? Thanks, -Original Message- Sent: Saturday, May 19, 2001 4:55 PM To: Multiple recipients of list ORACLE-L 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 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 file status > SVR4 Error: 2: No such file or directory > Additional information: 3 > > Please tell me why? I even change the directory to 777(anyone can read and > write) still gotta this error. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Chen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why I can not create temporary tablespace?
David,Can we use Locally managed tablespace for TEMP? Thanks, -Original Message- Sent: Saturday, May 19, 2001 4:55 PM To: Multiple recipients of list ORACLE-L 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 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 file status > SVR4 Error: 2: No such file or directory > Additional information: 3 > > Please tell me why? I even change the directory to 777(anyone can read and > write) still gotta this error. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Chen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why I can not create temporary tablespace?
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 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 file status > SVR4 Error: 2: No such file or directory > Additional information: 3 > > Please tell me why? I even change the directory to 777(anyone can read and > write) still gotta this error. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Chen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why I can not create temporary tablespace?
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 file status SVR4 Error: 2: No such file or directory Additional information: 3 Please tell me why? I even change the directory to 777(anyone can read and write) still gotta this error. But I try this one: create tablespace c3temp datafile '/oracle/home/oradata/c3temp.dat' size 1m; It works fine and tell me tablespace created. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Why I can not create temporary tablespace?
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 file status SVR4 Error: 2: No such file or directory Additional information: 3 Please tell me why? I even change the directory to 777(anyone can read and write) still gotta this error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
