Home » SQL & PL/SQL » SQL & PL/SQL » create temporary tablespace ...; V.S create tablespace ... temporary;
create temporary tablespace ...; V.S create tablespace ... temporary; [message #219125] Tue, 13 February 2007 01:48 Go to next message
Averell
Messages: 17
Registered: November 2006
Junior Member
Hi all,

I dont know what's the difference between these two sql commands:
create TEMPORARY TABLESPACE temp tempfile <file name> SIZE 52M;
create TABLESPACE temp datafile <file name> SIZE 52M TEMPORARY;


Could you please help.
Thank you very much!
Re: create temporary tablespace ...; V.S create tablespace ... temporary; [message #219203 is a reply to message #219125] Tue, 13 February 2007 09:58 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
Are you incapable or unwilling to read the SQL Reference Manual?
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
to answer this purely RTFM question?
Re: create temporary tablespace ...; V.S create tablespace ... temporary; [message #219359 is a reply to message #219203] Wed, 14 February 2007 02:43 Go to previous message
Averell
Messages: 17
Registered: November 2006
Junior Member
Hi anacedent
I'm sorry for that, but I can't find enough information about those two commands.
For example: in dba_tablespaces object, how could I know which one was created with TABLESPACE TEMPORARY, which one was created with TEMPORARY TABLESPACE command.
I'm trying to rebuild an index on a varchar2 column with few ten million key values. I tried to use two temporary tablespace above. And I saw difference performance. I dont know is that because of the tablespace themself or anything else.
Previous Topic: Checking record collection type for existing data
Next Topic: sql hard
Goto Forum:
  


Current Time: Tue Dec 06 10:04:03 CST 2016

Total time taken to generate the page: 0.12814 seconds