摘要:
(****使用闪回技术、首先要设置闪回恢复区)设置快速恢复区的地址SQL> alter system set db_recovery_file_dest='/u01/app/oracle/'scope=both;System altered.SQL> 设置快速恢复区的大小SQL> alter sys 阅读全文
摘要:
一:使用闪回技术操作数据时,首先应建立闪回恢复区 SQL> SQL> Show parameter recoverNAME TYPE VALUE db_recovery_file_dest string /home/oracle/shdb_recovery_file_dest_size big in 阅读全文
摘要:
一:典型安装的情况下包括Scott用户 ,默认情况下是锁定的状态,可以通过命令行来进行解锁; -:SQL> alter user scott account unlock identefied bu tiger;alter user scott account unlock identefied b 阅读全文
摘要:
1:select distinct department_id from employees; 2:select distinct department_id from employees where department_id is not null; 3:select distinct depa 阅读全文
摘要:
1 show user2 conn / as sysdba 3:alter user hr account unlock baocuo ORA-01017 1:conn / as sysdba 2: alter user hr identified by hr ; conn hr/hr 以上是关于h 阅读全文