?
Solved

Adding User to temporary tablespace

Posted on 2013-06-21
6
Medium Priority
?
434 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 2000 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

Independent Software Vendors: 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!

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

765 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