Oracle Database Training

If you cannot use a function in DBA, you can use sys.

Public Virtual User: Permission 1 and permission 2 are available to the public in the test environment, but copying the entire environment to the real environment means that the program cannot be used, the possible cause is that the public permission is not included, because the public permission is virtual.

 

Many important scripts in Oracle are in the directory $ ORACLE_HOME/rdbms /.

Indexes in Oracle must be rebuilt on a regular basis. If you want to re-index a large table, increase the virtual tablespace and modify some parameters.

When the Oracle view corresponds to all columns in a base table, you can add, delete, and modify views.

When the Oracle view maps to all non-empty fields in a base table, you can add, delete, and modify views.

 

OracleSequence:Oracle nocache does not generate a checkpoint.