This content has been marked as final. Show 5 replies
First two are in your recycle bin.1 person found this helpful
So I can drop them and no harm done.
What about the last two??
and the last two are consrtaints you defined without bothering to name them, eg:1 person found this helpful
orcl> create table t1(c1 number not null,c2 number unique); Table created. orcl> select constraint_name,constraint_type from user_constraints; CONSTRAINT_NAME C ------------------------------ - SYS_C0012030 C SYS_C0012031 U orcl>
You can display the contents of your recyclebin with this1 person found this helpful
SQL> show recyclebin
So I can drop them and no harm done.If you want to empty your recycle bin...
SQL> purge recyclebin;
And if you don't want items to go into the recycle bin and for the database to remove them completely you can set the initialisation parameter recyclebin to off - that would be an instance wide setting for no dropped objects being added to the recyclebin.1 person found this helpful