DB스토리

휴지통 비우기. S SYS> purge recyclebin; Recyclebin purged. S SYS> select * from dba_recyclebin; OWNER OBJECT_NAME ORIGINAL_NAME OPERATION ------------------------------ ------------------------------ -------------------------------- --------- TYPE TS_NAME CREATETIME DROPTIME DROPSCN ------------------------- ------------------------------ ------------------- ------------------- ---------- PARTITION_NA..

리스너를 실행시키는데 TNS:permission denied 가 나오는 문제가 발생. 확인결과 /var/tmp 폴더의 .oracle 폴더의 소유자가 root (

Archive log mode 확인 select log_mode from v$database; full backup 본 있을 것. rman target / list backup of database; rman 관련. RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTR..

-- 데이터의 이전. External Table insert into~ Loader yes --Create Directory S SYS> create directory dmpdir as '/home/oracle'; Directory created. S SYS> grant write,read on directory dmpdir to scott,hr; Grant succeeded. S SCOTT> select * from all_directories; OWNER DIRECTORY_NAME ------------------------------ ------------------------------ DIRECTORY_PATH -----------------------------------------------..