ITPub博客

只授予查看存储过程的权限grant debug any procedure to user ;

To take a datafile offline when the database is in NOARCHIVELOG mode, use the ALTER DATABASE statement with both the DATAFILE and OFFLINE FOR DROP clauses. ■ The OFFLINE keyword causes the database to mark the datafile OFFLINE, whether or not it is corrupted, so that you can open ...

1、增加一个日志组SQL> alter database add logfile group4('/u01/app/oracle/oradata/orcl/disk4/redo01.log') size 100m;2、给日志组增加一个成员SQL> alter database add logfile member'/u01/app/oracle/oradata/orcl/disk4/redo02.log' to group 4;3、手动切换当前日志组SQL> alter system switch lo...

1.创建临时表空间> create temporarytablespace temp2 tempfile '/u01/app/oracle/oradata/orcl/disk5/temp02.dbf' size50m autoextend on;2.更改默认临时表空间> alter databasedefault temporary tablespace temp2;更改临时表空间大小>ALTER TABLESPACE temp_demo ADD TEMPFILE 'temp05.dbf' SIZE 5 AUTOEXT...

1.创建用户> create user loan identified by loan default tablespace TBS_LOAN;2.创建表空间>create tablespace tbs_loan datafile '/data/oradata/credit/tbs_loan01.dbf' size 100m;3.修改用户的默认表空间> alter user core DEFAULT TABLESPACE TBS_CORE;4. 查看当前文件夹命令du -h5.解压和压...