Home > database >  Oracle how to delete the sys user under the table
Oracle how to delete the sys user under the table

Time:09-24

Just learn a few weeks of oracle, not careful in the imported form under the sys user guide, with the drop to delete an error, how can I delete these forms,

CodePudding user response:

Quote what error, you are to say ah, cut a figure can also;

CodePudding user response:

At least the error message posted

CodePudding user response:

Try it with the identity of the SYSDBA, or delete it directly in EM

CodePudding user response:

Well, delete the SYS user table, need to SYSDBA login to delete,

CodePudding user response:

Thrown object does not exist?
Normal can delete users set up table is no problem

CodePudding user response:

Import which tables are deleted which tables, pay attention to the case

CodePudding user response:

Should be able to delete it

CodePudding user response:

Log in to the sys user should be able to delete

CodePudding user response:

Coupled with the owner, and then use the sys user to delete,

CodePudding user response:

With the sys user login can be deleted,

CodePudding user response:

If it has the authority to delete user can:
Drop the user user_name cascade;
Added a cascade can delete all data on the user's joint and several

CodePudding user response:

Using sys user login, should be able to delete the sys user table below; You can also under the SYS user to create a new table, can try to delete,
  • Related