Oracle常用命令_Load

1.loading data using direct_load insert
  sql> insert /*+append */ into emp nologging
  sql> select * from emp_old;
   2.parallel direct-load insert
  sql> alter session enable parallel dml;
  sql> insert /*+parallel(emp,2) */ into emp nologging
   sql> select * from emp_old;
  3.using sql*loader
  sql> sqlldr scott/tiger sql> control = ulcase6.ctl sql> log = ulcas

Database error: [Table 'ac_search_cache' is marked as crashed and should be repaired]

SELECT * FROM ac_search_cache WHERE hash = '2809f5f9ccf1eb41eba065c9af242b0facc165d5' LIMIT 1;