asked on

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)

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

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.

patriotpacer

ASKER

Thanks, slightwv!

You're a good man.

slightwv (䄆 Netminder)

*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...

patriotpacer

ASKER

>>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.

slightwv (䄆 Netminder)

No problem.

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