-
Temporary tables and quotas on TEMP tablespace
Hi,
Sorting does not require any quotas on TEMP tablespace, as sorting is done by the system on behalf of the (DB) user.
How about dynamic SQL, which generates temporary tables ?
Do users need quota on TEMP tablespace for that - otherwise they won't be able to create and /or fill such tables ?
Thanks in advance,
Tajci
-
Have you tried out?
-
Hi.
Instead of creating temporary tables using dynamic SQL, why not use global temporary tables:
http://www.oracle-base.com/articles/...raryTables.php
It's going to be allot faster than issuing DDL statements.
Cheers
Tim...
-
Thanks for replies.
--------- o O o ---------
As far as I understood that, temporary tables are always created in the default temporary tablespace of the user creating (records in ) a temporary table.
Is this correct ?
The main question was:
Temporary or global temporary tables -
Whose quotas do temporary tables consume ?
Or, in other words:
Does a user need quotas on temporary tablespace to create /and or insert into temporary tables ???
Or is it the system who creates temp tables or records on behalf of the user issuing an insert (or create) - as for sorting applies ?
Thanks in advance,
Tajci
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|