Solved

Adding User to temporary tablespace

Posted on 2013-06-21
6
422 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
  • 4
  • 2
6 Comments
 
LVL 76

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 76

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

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 76

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query Records that don't match 8 42
execute immediate plsql block 5 45
Oracle - SQL Where clause causing Invalid Number Error 4 32
PL SQL Developer 7 32
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now