Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to enable recycle bin & assign Default Tablespace in Ora 10g XE?

senthilmcaNov 30 2007 — edited Nov 30 2007
I am using Oracle 10g Express Edition..
i drop the objects from the database but it does not stored in the recycle bin. how can i resolve this problem.

How to enable recycle bin and PURGE options?

I had followd PaulM reply (1619135

sql>select DEFAULT_TABLESPACE from dba_users where username = 'test';

It shows no data found.
How to assign a Default TableSpace to a user?
While creating a user it takes some default tablespace know?
Why it shows 'No data Found'?

Thanks

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 28 2007
Added on Nov 30 2007
7 comments
2,221 views