Skip to Main Content
Forums

SQL & PL/SQL

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.

table spaces are not dropping

Prabhakar KSep 25 2017 — edited Sep 25 2017

Hi

I have a user called hdm_dbuser. and I have created new user and table spaces based on HDM_dbuser.

now I don't want hdm_dbuser2. I have dropped user like ..

drop user hdm_dbuser2 cascade;

user dropped.

then I started dropping table spaces.

Drop tablespace hdm_dbuser2_data including contents and datafiles;

I am getting the below ORA errors

ORA-00604 - error occurred at recursive sql level 1

ORA-02429 - cant drop index used for enforcement of unique / primary key

Please advise...!

Regards

FRD
This post has been answered by KPR on Sep 25 2017
Jump to Answer

Comments

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

Post Details

Locked on Oct 23 2017
Added on Sep 25 2017
8 comments
175 views