態度

可以選擇自暴自棄，知命和認命，又或者是:挑戰自己?
最大對手永遠都是自己！

Jobs in oracle

--Job in oracle select * from dba_datapump_jobs;
SELECT * FROM V$DATAPUMP_SESSION;
begin
dbms_datapump.detach(45);
end;

select * from DBA_JOBS ;
SELECT * FROM ALL_JOBS ;
SELECT * FROM USER_JOBS;
SELECT * FROM DBA_JOBS_RUNNING ;

Clone oracle db

1) in orginal db, alter database backup controlfile to trace;

2) it generates a script containing a create controlfile command and store it in the trace directory identified in the user_dump_dest parameter of the init.ora

3) shutdown original db NORMAL/IMMEDIATE;

4) copy whole db directory to new destination

5) edit the init file to change the new path, and delete the old control files

6) [windows] drop and create the service

7) run the trace file sql....CREATE CONTROLFILE SET DATABASE "MMBO8" RESETLOGS NOARCHIVELOG.....

8) alter database open resetlogs;9) may need to add back temp file to temp tablespace