• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 438
  • Last Modified:

Adding User to temporary tablespace

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
patriotpacer
Asked:
patriotpacer
  • 4
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
patriotpacerAuthor Commented:
Thanks, slightwv!

You're a good man.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
slightwv (䄆 Netminder) Commented:
*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
 
patriotpacerAuthor Commented:
>>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
 
slightwv (䄆 Netminder) Commented:
No problem.

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now