Search code examples
sqloracleplsqloracle-sqldeveloper

all table, constraint,... i have deleted still exist in new connection ORACLE


all table, constraint,... i have deleted still exist in new connection ORACLE ** is there any solution to delete schema in oracle**


Solution

  • Do you want to drop your schema? Then use

    DROP SCHEMA schemaName RESTRICT;
    

    If you can delete the user then all associated object/schema will be deleted.

    DROP USER username CASCADE;