-
编辑 删除
Oracle10g sql execute plan auto removes unnecessary table
SQL> explain plan for select * from emp;已解释。SQL> select * from table(dbms_xplan.display);PLAN_TABLE_OUTPUT--------------------------------------------------------------------------------Plan h...
-
编辑 删除
Oracle 10g transportable tablespace
goal: transport tablespace of source to target cross platform.source environment: 10.2.0.1 redhat 4 as 7 64 bittarget environment: 10.2.0.1 windows xp 32 bit1.check os of source and target database:...
-
编辑 删除
Oracle 10g document error
To use RMAN with a shared server:Create a net service name in the tnsnames.ora file that connects to the non-shared SID. For example, enter:inst1_ded = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)...
-
编辑 删除
user backed up controlfile to recover database
simulate all controlfile lost, use backed up controlfile or snapshot controlfile to recovery. snaphost controlfile locates in ?/dbs/ --unix/linux or ?/database/ --windows0.simulate the en...
-
编辑 删除
recover all online redo logfile media which were lost
1.shutdown rdbmsSQL> shutdown immediate;数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。2.delete all online redo logfile mediaC:\>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production ...
-
编辑 删除
use old datafile and latest log and current controlfile to recover database
1.create table t_emp and get scn of database.SQL> show user;USER 为 "SCOTT"SQL> create table t_emp as select * from emp;表已创建。SQL> select current_scn from v$database;CURRENT_SCN-------...
