OraFAQ Forum: Server Administration » Temporary tables

Home » RDBMS Server » Server Administration » Temporary tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temporary tables [message #119639]

Fri, 13 May 2005 10:37

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi,
Temporary tables are created in one's default temporary tablespace. User "A" creates a temporary table inside a procedure and give execute permission to another user "B" and B executes the procedure. In which tablespace will the temporary table be created?
"B" default temporary tablespace
or
"A" default temporary tablespace

Thanks in advance
qA

Report message to a moderator

Re: Temporary tables [message #119651 is a reply to message #119639]

Fri, 13 May 2005 11:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

GTT takes no storage, until it is been used.
When needed it will use TEMP tablespace of the OWNER ("A" in your case).

Report message to a moderator

Re: Temporary tables [message #119653 is a reply to message #119651]

Fri, 13 May 2005 11:19

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Thank you very much for your reply.

Regards,
Anand

Report message to a moderator

Previous Topic:	read records from Oracle database and insert into 9i database
Next Topic:	Software Updates & Patches

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 08 17:07:27 CDT 2026