Solved

Adding User to temporary tablespace

Posted on 2013-06-21
6
431 Views
Last Modified: 2013-06-21
I get an error running a dbms_metadata.get_ddl query.  I need to have the DBA fix it, but I need to understand if what I'm asking the DBA to do is practical.  This is not a production database, by the way.

Error:  Temporary Tablespace is Empty

If I ask the DBA to alter my account and add temporary tablespace, is that correct?  Is this something common?  

(I'm not oracle by background)
0
Comment
Question by:patriotpacer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39266520
From your previous question, your user's default temp tablespace is named TEMP.

Just have the DBA create a temporary tablespace named TEMP and you should be good to go.

As far as being practical, I mentioned this in the other question as well.  Oracle should have a temporary tablespace.  If it doesn't, then it uses the SYSTEM tablespace (at least it used to) to do things like sorting.  This isn't a great way to run a database even if it isn't production.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39266525
I suppose I should add that the DBA 'can' call it anything they want.  TEMP is sort of standard.

They would just make it the database's default temporary tablespace then alter the user's default to that.
0
 

Author Comment

by:patriotpacer
ID: 39266531
Thanks, slightwv!

You're a good man.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39266543
*blushes*

Thanks.  I try to be...  :)


I know you are frustrated with Oracle right now but give it a chance.  The very little I do with SQL Server, I cannot imagine people actually use it.  It's so foreign to me...
0
 

Author Comment

by:patriotpacer
ID: 39266553
>>I know you are frustrated with Oracle right now but give it a chance.  The very little I do with SQL Server, I cannot imagine people actually use it.  It's so foreign to me..

Just seems there's so many little configurations in Oracle.  But I imagine that's a good thing for flexibility, tuning, etc...

I honestly appreciate all the help you've given me.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39266566
No problem.

The Oracle guys here on EE are all pretty good.  Ask away, we'll help convert you!
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question