orcl

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production With the Partitioning option JServer Release 8.1.7.4.1 - Production Export done in KO16KSC5601 character set and KO16KSC5601FIXED NCHAR character set About to export specified tables via Conventional Path ... . . exporting table DATAFIRST . . exporting partition DATAFIRST_200605잘못된 명령어(coredump) direct = y 옵션을 준후 정상 About t..

When performing a consistent export (i.e. setting CONSISTENT=Y), do not use the SYS user, or connect as SYSDBA. If you do, there is no guarentee from Oracle that the exported data will be consistent. When you perform a consistent export, Oracle issues the statement 'SET TRANSACTION READ ONLY' (see utilities manual on consistent parmaeter for export). Setting a transaction to READ ONLY does not w..

8i-특정 테이블을 제외(SKIP)하고 EXPORT 하는 방법 ================================================ PURPOSE -------- Fine-Grained Access (FGAC) control을 이용하여 특정 테이블을 제외하고 Export Explanation & Example ---------------------- 이 방법은 FGAC을 지원하는 Oracle Version에서만 가능하다. Oracle 8i에서부터 FGAC을 지원하며 Standard Edition을 제외한 Enterprise Edition 과 Personal Edition에서 지원한다. 아래는 Scott User에서 EMP,DEPT 테이블을 제외하고 export받는 예제이다. 1. SYS..