Oracle tablespace offline online switching and database shutdown start operation diagram

Look at the operation of the elder brother;

User Atongmu connection, modify table space users offline, prompt permission is insufficient;

Oracle roughly says: Find a database administrator to do the operation, or let him give you the permissions you need;

SYS user connection, the change was successful;

Then open the table, the following prompts, unable to read the data file;

Use this command to modify the online;

ALTER tablespace XXXXXXX ONLINE;

The following experiment closes the open database;

Open a system table first to see;

connection from SQL Plus; the first time the wrong password was lost;

password expiration; reset password;

Close the database, insufficient permissions;

Connect with SYSDBA identity;

Then open the table in SQL Developer, and the following prompts appear;

Start a database; succeed;

Close the previous connection in SQL Developer, and then reopen it to operate;