By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,028 Members | 1,869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,028 IT Pros & Developers. It's quick & easy.

Which table space associated with Global Temporary

P: 5
When we create an object in oracle we can specify table space, if not it will take default table space, while creating global temporary table how can we specify the table space...and even if we create temp table without mentioning table space where the structure of the temp table stored and when we are trying to insert data into it which table space it will use....?

I faced one problem earlier that..I can describe the table but when iam trying to insert the values into temp table--> error raised that 'table space <tamp----> does not exist'. Finally i solved the problem by creating the table space with the given name but still i have doubt...please clarify.....
Sep 12 '07 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
Please find details of global temporary tables here ,here and here.
Sep 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.