1.控制文件被强行删除后,数据库未关闭情况下 1.1查看控制文件位置 SYS@EVA>show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string /u01/app
启动数据库的时候 SQL> startup mount; ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initprod.ora' less /u01/app/oracle/
一、授予和撤销系统权限: 1. DBA 将CREATE TABLE 系统权限连同ADMIN OPTION 授予U01。 SQL> create user u01 identified by oracle default tablespace users quota 10m on users; SQL> grant connect to u01; SQL> grant create table t