{"id":3640,"date":"2018-03-19T11:13:44","date_gmt":"2018-03-19T02:13:44","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3640"},"modified":"2018-03-19T11:13:44","modified_gmt":"2018-03-19T02:13:44","slug":"oracle-exp-imp","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3640","title":{"rendered":"ORACLE EXP , IMP"},"content":{"rendered":"

Export & Import
\n<\/span><\/h2>\n

EXPORT \ub294 DATA\ub97c ORACLE DATABASE\ub85c\ubd80\ud130 ORACLE Binary \ud615\ud0dc\uc758 OS FILE\ub85c \ub9cc\ub4e4\uace0 IMPORT\ub97c \uc774\uc6a9\ud558\uc5ec DATABASE\ub85c LOADING \ud55c\ub2e4.
\n<\/span><\/p>\n

Export
\n<\/span><\/h3>\n


\n<\/span>ORACLE DATABASE\ub97c OS file\ub85c \ub9cc\ub4dc\ub294 \uc791\uc5c5\uc774\ub2e4. \uc774 \uc791\uc5c5\uc740 DATABASE\uac00 OPEN \ub418\uc5b4\uc788\ub294 \ub3d9\uc548\uc5d0 \uc2e4\uc2dc \ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

EXPORT MODE
\n<\/span><\/h4>\n

Export \uc791\uc5c5\uc744 \uc218\ud589 \ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc73c\ub85c\ub294 \uc544\ub798\uc758 3\uac00\uc9c0 \ubc29\ubc95\uc73c\ub85c \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4.
\n<\/span><\/p>\n

USER \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc5b4\ub5a4 \uc720\uc800\uc18c\uc720\uc758 \ubaa8\ub4e0 \uc624\ube0c\uc81d\ud2b8\ub97c
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0TABLES \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc5b4\ub5a4 \uc720\uc800\uc18c\uc720\uc758 \ubaa8\ub4e0 \ud639\uc740 \ud2b9\uc815 \ud14c\uc774\ube14\ub9cc
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0FULL DATABASE \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 \uc624\ube0c\uc81d\ud2b8\ub97c
\n<\/span><\/p>\n

\uc0ac\uc6a9 \uc608>
\n<\/span><\/p>\n

TABLES=table_lists \ub610\ub294
\n<\/span><\/p>\n

OWNER=owner_lists \ub610\ub294
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0FULL=Y
\n<\/span><\/p>\n

EXPORT TYPE
\n<\/span><\/h4>\n

Export Type\uc740 backup\ub418\ub294 \uc591\uc5d0 \ub530\ub77c 3\uac00\uc9c0 \ubc29\ubc95\uc774 \uc720\uc6a9\ud558\ub2e4. \uadf8\ub7ec\ub098 \uac00\ub2a5\ud558\uba74 \ub9ce\uc740 \uc2dc\uac04\uc774 \uc18c\uc694\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0\ub77c\uba74 Complete\ub85c \uc791\uc5c5\ud558\ub294 \uac83\uc774 \ubc14\ub78c\uc9c1\ud558\ub2e4.
\n<\/span><\/p>\n

COMPLETE<\/strong> : \uc804\uccb4 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c EXPORT \ud55c\ub2e4.
\n<\/span><\/p>\n

CUMULATIVE<\/strong> : \ub9c8\uc9c0\ub9c9 “COMPLETE” \ud639\uc740 “CUMULATIVE” EXPORT \uc774\ud6c4\uc5d0 \ubcc0\uacbd\ub41c \uc815\ubcf4\ub97c EXPORT \ud55c\ub2e4.
\n<\/span><\/p>\n

INCREMENTAL<\/strong> : \ub9c8\uc9c0\ub9c9 “COMPLETE”,”CUMULATIVE” \ud639\uc740 “INCREMENTAL” EXPORT \uc774\ud6c4\uc5d0 \ubcc0\uacbd\ub41c \uc815\ubcf4\ub97c EXPORT \ud55c\ub2e4.
\n<\/span><\/p>\n

BACKUP \ubc29\ubc95\uc740 \ub9e4\uc6d4 1 \uc77c\uc5d0 “COMPLETE”, \uc8fc\ub9d0\uc5d0 “CUMULATIVE”, \uc8fc\uc911\uc5d0\ub294 “INCREMENTAL”\ub85c \ud558\uba74 \uac00\uc7a5 \uc801\uc808\ud558\ub2e4.
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0INCREMENTAL \u00a0\u00a0\u00a0\u00a0DAILY
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0CUMULATIVE \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WEEKLY
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0COMPLETE \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MONTHLY
\n<\/span><\/p>\n

Export \ud558\uae30 \uc804\uc5d0\ub294 DISK\uc6a9\ub7c9\uc774 \ucda9\ubd84\ud55c\uc9c0\ub97c \uba3c\uc800 CHECK \ub9cc\uc57d DISK \uac00 \ubaa8\uc790\ub77c\uba74 WRITE_FAILURE ERROR\uac00 \ubc1c\uc0dd\ud55c\ub2e4. TABLE_SIZE\ub294 USER_SEGMENTS view\uc5d0\uc11c \ubcfc \uc218 \uc788\ub2e4
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\uc8fc> Export\uc2dc\uc5d0\ub294 CLUSTER DEFINETION\uc774\ub098 ROLLBACK SEGMENT\uc758 OPTIMAL option\uc740 Export\ub418\uc9c0 \uc54a\ub294\ub2e4.
\n<\/span><\/p>\n

\uc8fc> SYS \uc18c\uc720\uc758 object\ub294 Export\ub418\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \uc5b4\ub5a0\ud55c object\ub77c\ub3c4 SYS\uc758 \uc720\uc800\ub85c \ub9cc\ub4e4\uc9c0 \ub9d0 \uac83
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\uc8fc> sequence number\ub294 Export \ub3c4\uc911\uc5d4 access\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud560 \uac83
\n<\/span><\/p>\n

EXPORT \uc791\uc5c5 \uc218\ud589
\n<\/span><\/h3>\n

Export \uc791\uc5c5 \ubc29\ubc95
\n<\/span><\/h4>\n

$ exp keyword=value \ud615\ud0dc
\n<\/span><\/p>\n

ex> exp SCOTT\/TIGER GRANTS=Y TABLES=(EMP, DEPT, MGR)
\n<\/span><\/p>\n

KEYWORD \ub0b4\uc6a9
\n<\/span><\/h4>\n

USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 username\/password
\n<\/span><\/p>\n

BUFFER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 size of data buffer
\n<\/span><\/p>\n

FILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 outfile(default \ub294 EXPDAT.DMP)
\n<\/span><\/p>\n

COMPRESS\u00a0\u00a0\u00a0\u00a0 import into one exetent (Y)
\n<\/span><\/p>\n

GRANTS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 export grants(Y)
\n<\/span><\/p>\n

INDEXES\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 export indexes(Y)
\n<\/span><\/p>\n

ROWS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 export data rows(Y)
\n<\/span><\/p>\n

CONSTRAINTS\u00a0\u00a0\u00a0\u00a0 export constraints(Y)
\n<\/span><\/p>\n

LOG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 log file of screen output
\n<\/span><\/p>\n

FULL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 export entire file(N)
\n<\/span><\/p>\n

OWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 list of owner username
\n<\/span><\/p>\n

TABLES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 list of tablename
\n<\/span><\/p>\n

RECORDLENGTH\u00a0\u00a0\u00a0\u00a0 length of IO record
\n<\/span><\/p>\n

INCTYPE\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 incremental export type
\n<\/span><\/p>\n

RECORD\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 track incr.export(Y)
\n<\/span><\/p>\n

PARFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 parameter file name
\n<\/span><\/p>\n

CONSISTENT\u00a0\u00a0\u00a0\u00a0 cross-table consistent
\n<\/span><\/p>\n

STATISTICS\u00a0\u00a0\u00a0\u00a0 analyze objects(ESTIMATE)
\n<\/span><\/p>\n

Parameter file\uc744 \uc774\uc6a9\ud558\ub294 \uacbd\uc6b0
\n<\/span><\/h4>\n

$ exp username\/password PARFILE=filename
\n<\/span><\/p>\n

\uc704\uc758 OPTION\ub4e4\uc744 PARAMETER FILE\uc548\uc5d0 \ubb36\uc5b4\uc11c \uac04\ub2e8\ud788 \uc9c0\uc815
\n<\/span><\/p>\n

ex>vi filename
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0SYSTEM\/MANAGER
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0FULL=Y
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0FILE=DBA.DMP
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0GRANTS=Y
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0INDEXES=Y
\n<\/span><\/p>\n

Export \uc791\uc5c5 Test
\n<\/span><\/h3>\n

\uc804\uccb4 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 EXPORT (Interactive Method)
\n<\/span><\/h4>\n

$ exp system\/manager
\n<\/span><\/p>\n

Connected to: ORACLE7 Server Release 7.0.16.4.0 – Production
\n<\/span><\/p>\n

With the procedural and distributed options
\n<\/span><\/p>\n

PL\/SQL Release 2.0.18.1.0 – Production
\n<\/span><\/p>\n

Enter array fetch buffer size : 4096 >(RETURN)
\n<\/span><\/p>\n

Export file : expdat.dmp >
\n<\/span><\/p>\n

(1) E(ntire database), (2) U(sers), (3) T(ables) : (2) U > e
\n<\/span><\/p>\n

Export grants (Y\/N) : Y > y
\n<\/span><\/p>\n

Export table data (Y\/N) : Y > y
\n<\/span><\/p>\n

Compress extents (Y\/N) : Y > y
\n<\/span><\/p>\n

About to export the entire database….
\n<\/span><\/p>\n

. exporting tablespace definitions
\n<\/span><\/p>\n

. exporting profiles
\n<\/span><\/p>\n

. exporting user definitions
\n<\/span><\/p>\n

. exporting role
\n<\/span><\/p>\n

. exporting rollback segment definitions
\n<\/span><\/p>\n

. exporting database links
\n<\/span><\/p>\n

. exporting sequence numbers
\n<\/span><\/p>\n

. exporting sequence numbers
\n<\/span><\/p>\n

. exporting cluster definitions
\n<\/span><\/p>\n

. exporting stored procedures
\n<\/span><\/p>\n

. about to export SYSTEM’s tables …
\n<\/span><\/p>\n

. about to export SCOTT’s tables …
\n<\/span><\/p>\n

. exporting synonyms
\n<\/span><\/p>\n

. exporting views
\n<\/span><\/p>\n

. exporting referential integrity constraints
\n<\/span><\/p>\n

. exporting triggers
\n<\/span><\/p>\n

Export terminated successfully without warnings.
\n<\/span><\/p>\n

\uc804\uccb4 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 EXPORT (Command Line Method)
\n<\/span><\/h4>\n

$ exp userid=system\/manager full=y compress=y grants=y rows=y
\n<\/span><\/p>\n

\uc804\uccb4 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 EXPORT ( Dynamic Method )
\n<\/span><\/h4>\n

EXPORT PARAMETERS \uc744 \ub2e4\uc74c\uacfc \uac19\uc740 FILE(tusc.par) \ud615\ud0dc\ub85c \ub9cc\ub4e0\ub2e4.
\n<\/span><\/p>\n

system\/manager
\n<\/span><\/p>\n

full=y
\n<\/span><\/p>\n

compress=y
\n<\/span><\/p>\n

grants=y
\n<\/span><\/p>\n

rows=y
\n<\/span><\/p>\n

$ exp parfile=tusc.par
\n<\/span><\/p>\n

USER only EXPORT
\n<\/span><\/h4>\n

$ exp system\/manager
\n<\/span><\/p>\n

Connected to: ORACLE7 Server Release 7.0.16.4.0 – Production
\n<\/span><\/p>\n

With the procedural and distributed options
\n<\/span><\/p>\n

PL\/SQL Release 2.0.18.1.0 – Production
\n<\/span><\/p>\n

Enter array fetch buffer size : 4096 >(RETURN)
\n<\/span><\/p>\n

Export file : expdat.dmp >
\n<\/span><\/p>\n

(1) E(ntire database), (2) U(sers), (3) T(ables) : (2) U > u
\n<\/span><\/p>\n

Export grants (Y\/N) : Y > y
\n<\/span><\/p>\n

Export table data (Y\/N) : Y > y
\n<\/span><\/p>\n

Compress extents (Y\/N) : Y > y
\n<\/span><\/p>\n

About to export specified users
\n<\/span><\/p>\n

User to be exported: (RETURN to quit) > scott
\n<\/span><\/p>\n

. exporting snapshots
\n<\/span><\/p>\n

. exporting snapshot log
\n<\/span><\/p>\n

. exporting database links
\n<\/span><\/p>\n

. exporting sequence numbers
\n<\/span><\/p>\n

. exporting sequence numbers
\n<\/span><\/p>\n

. exporting cluster definitions
\n<\/span><\/p>\n

. exporting stored procedures
\n<\/span><\/p>\n

. about to export SCOTT’s tables …
\n<\/span><\/p>\n

. exporting synonyms
\n<\/span><\/p>\n

. exporting views
\n<\/span><\/p>\n

. exporting referential integrity constraints
\n<\/span><\/p>\n

. exporting triggers
\n<\/span><\/p>\n

Export terminated successfully without warnings.
\n<\/span><\/p>\n

USER only EXPORT (Command Line Method)
\n<\/span><\/h4>\n

$ exp userid=system\/manager owner=scott compress=y grants=y rows=y
\n<\/span><\/p>\n

USER ONLY EXPORT ( Dynamic Method )
\n<\/span><\/h4>\n

EXPORT PARAMETERS \uc744 \ub2e4\uc74c\uacfc \uac19\uc740 FILE(tusc.par) \ud615\ud0dc\ub85c \ub9cc\ub4e0\ub2e4.
\n<\/span><\/p>\n

system\/manager
\n<\/span><\/p>\n

owner=scott
\n<\/span><\/p>\n

compress=y
\n<\/span><\/p>\n

grants=y
\n<\/span><\/p>\n

rows=y
\n<\/span><\/p>\n

$ exp parfile=tusc.par
\n<\/span><\/p>\n

TABLES EXPORT
\n<\/span><\/h4>\n

$ exp scott\/tiger tables=emp,dept compress=y grants=y rows=y
\n<\/span><\/p>\n

INCREMENTAL EXPORT
\n<\/span><\/h4>\n

INCREMENTAL EXPORT \ub294 SYS \ud639\uc740 SYSTEM USER\ub85c\uc11c EXPORT \ud55c\ub2e4.\ub9cc\uc77c FILE \uc774\ub984\uc744 “expdat.dmp”\uc5d0\uc11c \ub2e4\ub978 \uc774\ub984\uc73c\ub85c \ubcc0\uacbd\ud558\uace0\uc790 \ud560 \ub54c\ub294 COMMAND LINE\uc5d0\uc11c FILENAME \ub9cc \uc9c0\uc815\ud558\uba74 \ub41c\ub2e4.
\n<\/span><\/p>\n

$ exp system\/manager inctype=complete file=com0304.dmp
\n<\/span><\/p>\n

$ exp system\/manager inctype=incremental file=inc0305.dmp
\n<\/span><\/p>\n

\uc8fc\uc758: INCREMENTAL EXPORT \ub370\uc774\ud0c0\uc591\uc740 “NEW \ud639\uc740 UPDATE” \ub41c TABLE\uc758 \uac2f \uc218\uc5d0 \ub530\ub77c \ud06c\uac8c \ub2e4\ub97c \uc218 \uc788\ub2e4. \uc989 \ud558\ub098\uc758 \ud070 TABLE \uc774 \ub9e4\uc77c UPDATE \ub418\uba74 \ud56d\uc0c1 EXPORT \ub418\uace0 UPDATE \uac00 \uc548\ub418\uba74 FULL EXPORT \uc758 1% \uc815\ub3c4 \ub420 \uc218 \uc788\ub2e4. \ub530\ub77c\uc11c \uc774 \ubc29\ubc95\uc740 \ubaa8\ub4e0 TABLE \uc774 \ub9e4\uc77c UPDATE \uac00 \ubc1c\uc0dd\ud558\uba74 \ube44\ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc774 \ub41c\ub2e4.
\n<\/span><\/p>\n

Export\/Import Q & A
\n<\/span><\/h3>\n

RDBMS\uc640 Export, Import\uc758 \uc5f0\uad00\uad00\uacc4\ub294 (catexp.sql \uc774\ub780) ?
\n<\/span><\/h4>\n

Export, Import\uc2dc \uc774\ubbf8 \uc0dd\uc131\ub41c \uc624\ube0c\uc81d\ud2b8\uc758 \uc815\ubcf4\ub97c \ub370\uc774\ud0c0 \ub515\uc154\ub108\ub9ac\uc5d0\uc11c \ucffc\ub9ac\ub97c \ud558\ub294\ub370 \uc774\ub7ec\ud55c \uc624\ube0c\uc81d\ud2b8\uc758 \uc815\ubcf4\uac00 \ub370\uc774\ud0c0 \ub515\uc154\ub108\ub9ac\ub0b4\uc758 \uc5ec\ub7ec \ud14c\uc774\ube14\uc5d0 \ub098\ub204\uc5b4\uc838 \uc788\ub2e4. \ud544\uc694\ud55c \ub370\uc774\ud0c0 \ub515\uc154\ub108\ub9ac \uc815\ubcf4\ub97c \ud3b8\ub9ac\ud558\uac8c \uc774\uc6a9\ud558\uae30 \uc704\ud558\uc5ec \uc5ec\ub7ec \uac00\uc9c0\uc758 \ubdf0\ub97c catexp.sql\uc5d0 Script\ub418\uc5b4 \uc788\ub2e4. \uc774 \uc2a4\ud06c\ub9bd\ud2b8\ud654\uc77c\uc740 $ORACLE_HOME\/rdbms\/admin\uc5d0 \uc788\uc73c\uba70 Install\uc2dc \uc218\ud589\ub418\ub3c4\ub85d \ub418\uc5b4 \uc788\ub2e4.
\n<\/span><\/p>\n

Export\uc2dc \uc624\ube0c\uc81d\ud2b8\uc758 \ubc31\uc5c5 \uc21c\uc11c\ub294 \uc788\ub294\uac00 ?
\n<\/span><\/h4>\n

Export\ud558\ub294 \uc624\ube0c\uc81d\ud2b8\uc758 \uc21c\uc11c\ub294 \uc874\uc7ac\ud558\uba70 \uc774\ub294 Oracle\uc758 Version Up\ub4f1\uc5d0 \uc758\ud55c \uc0c8\ub85c\uc6b4 \uc624\ube0c\uc81d\ud2b8\uac00 \ub9cc\ub4e4\uc5b4\uc9c0\uac70\ub098 \ud558\uba74 Export\ub418\ub294 \uc624\ube0c\uc81d\ud2b8\uc758 \uc21c\uc11c\ub294 \ubcc0\ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

\uc624\ube0c\uc81d\ud2b8\uc758 Export\uc21c\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.
\n<\/span><\/p>\n

Tablespaces
\n<\/span><\/p>\n

Profiles
\n<\/span><\/p>\n

Users
\n<\/span><\/p>\n

Roles
\n<\/span><\/p>\n

System Privilege Grants
\n<\/span><\/p>\n

Role Grants
\n<\/span><\/p>\n

Default Roles
\n<\/span><\/p>\n

Tablespace Quotas
\n<\/span><\/p>\n

Resource Costs
\n<\/span><\/p>\n

Rollback Segments
\n<\/span><\/p>\n

Database Links
\n<\/span><\/p>\n

Sequences( includes Grants )
\n<\/span><\/p>\n

Snapshots ( includes grants, auditing )
\n<\/span><\/p>\n

Snapshot logs
\n<\/span><\/p>\n

Job Queues
\n<\/span><\/p>\n

Refresh Groups
\n<\/span><\/p>\n

Cluster Definitions
\n<\/span><\/p>\n

Tables(includes grants,column grants,comments,indexes,constraints,auditing)
\n<\/span><\/p>\n

Referential Integrity
\n<\/span><\/p>\n

POSTTABLES actions
\n<\/span><\/p>\n

Synonyms
\n<\/span><\/p>\n

Views
\n<\/span><\/p>\n

Stored Procedures
\n<\/span><\/p>\n

Triggers
\n<\/span><\/p>\n

Default and System Auditing
\n<\/span><\/p>\n

Export\uc2dc BUFFER\uc640 RECORDLENGTH\ub294 \ubb34\uc5c7\uc778\uac00?
\n<\/span><\/h4>\n

BUFFER : Export\uc2dc \uc624\ube0c\uc81d\ud2b8\ub0b4\uc5d0 \uc788\ub294 \uc5ec\ub7ec \uac1c\uc758 Row\uac00 \ud55c\uaebc\ubc88\uc5d0 Fetch\ub41c\ub2e4. \ub514\uc2a4\ud06c\uc5d0\uc11c Fetch\ub41c \uc815\ubcf4\ub294 \ud654\uc77c\uc5d0 Write\ud558\uae30 \uc804\uc5d0 \uba54\ubaa8\ub9ac\ub97c \uac70\uce58\uac8c \ub418\uba70, \uc774\ub54c \ud560\ub2f9\ub418\ub294 \uba54\ubaa8\ub9ac\uc758 \uc591\uc774 Buffer \ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc774\ub2e4.
\n<\/span><\/p>\n

RECORDLENGTH : \uba54\ubaa8\ub9ac\uc5d0 \uc788\ub294 Export\ud560 \uc790\ub8cc\ub97c \ud654\uc77c\uc5d0 Write\ud558\uae30 \uc704\ud574 \ud55c\ubc88\uc5d0 \uc6b4\ubc18\ub418\ub294 \uc591\uc744 \uacb0\uc815\ud558\ub294 \ud30c\ub77c\ubbf8\ud130\uc774\ub2e4.
\n<\/span><\/p>\n

[\uc8fc\uc758] \uc704\uc758 BUFFER\uc640 RECORDLENGTH\ub294 O\/S\uc758 Block Size\uc758 \ubc30\uc218\uac00 \ub418\ub3c4\ub85d \ud558\ub294 \uac83\uc774 \ud6a8\uc728\uc801\uc774\ub2e4.
\n<\/span><\/p>\n

\ub2e4\ub7c9\uc758 Row\ub97c Export, Import\uc2dc \uc5b4\ub290 \uc815\ub3c4\uc758 Row\uac00 \ucc98\ub9ac\ub418\uc5c8\ub294\uc9c0 \uc54c \uc218 \uc788\ub294\uac00?
\n<\/span><\/h4>\n

\uc54c \uc218 \uc788\ub2e4. V 7.1\uae4c\uc9c0\ub294 \ub2e4\ub7c9\uc758 Row\ub97c Export, Import\uc2dc \ucc98\ub9ac\ub41c \uc815\ub3c4\ub97c \uc54c \uc218\uac00 \uc5c6\uc5b4 \ud604\uc7ac \uc791\uc5c5 \uc911\uc778\uc9c0 \uc2dc\uc2a4\ud15c\uc774 Hang\uc778\uc9c0 \ud30c\uc545\ub418\uc9c0 \uc54a\uc558\uc73c\ub098 V 7.2\ubd80\ud130\ub294 FEEDBACK \uc774\ub77c\ub294 \uc635\uc158\uc744 \uc774\uc6a9\ud558\uc5ec \uccb4\ud06c\uac00 \uac00\ub2a5\ud558\ub2e4.
\n<\/span><\/p>\n

Export\uc2dc \ud55c\ubc88\uc5d0 \uba87 \uac1c\uc758 Row\uac00 Fetch\ub418\ub294\uac00?
\n<\/span><\/h4>\n

\ud55c\ubc88\uc5d0 Fetch\ub418\ub294 Row\uc758 \uc218\ub294 Buffer Size\uc640 \uc5f0\uad00 \uad00\uacc4\uac00 \uc788\ub2e4. \ud558\ub098\uc758 Row\uac00 Export\uc2dc \ucc28\uc9c0\ud558\ub294 \uc591\uc740 \uac01 Column Size\uc758 \ud569 + 4 * (Column\uc758 \uc218)\ub85c \uad6c\ud560 \uc218 \uc788\ub2e4. \ud55c\ubc88 Fetch \ub418\ub294 Row\uc758 \uc218\ub294 Buffer Size \/ \ud55c Row\uc758 Export\uc2dc Size\uc774\ub2e4. \uc774\ub97c \uc774\uc6a9\ud558\uba74 Export\ub41c Output File\uc758 Size\ub294 \ub300\ub7b5 \ud55c Row\uc758 Export\uc2dc Size * Row \uc218 \uc774\ub2e4.
\n<\/span><\/p>\n

Export, Import\uc758 \ud638\ud658\uc131\uc740 \uc5b4\ub5bb\uac8c \ub418\ub294\uac00?
\n<\/span><\/h4>\n

Export, Import\uc758 \ud638\ud658\uc131\uc740 Oracle\uc758 \ubc84\uc804\uacfc \uc9c1\uc811\uc801\uc778 \uc5f0\uad00 \uad00\uacc4\ub97c \uac16\uace0 \uc788\ub2e4.
\n<\/span><\/p>\n

\ud638\ud658\uc131\uc740 4\uac00\uc9c0\ub85c \ub098\ub204\uc5b4 \uc124\uba85\ud560 \uc218 \uc788\uc73c\uba70 \uc774\ub97c \uc544\ub798\uc758 \uac00\uc815\uc744 \uc774\uc6a9\ud574 \uc124\uba85\ud558\uaca0\ub2e4.
\n<\/span><\/p>\n

\uac00\uc815 A\ub77c\ub294 \uae30\uacc4\uc5d0 Oracle V 7.0, B \ub77c\ub294 \uae30\uacc4\uc5d0\ub294 Oracle V 7.1\uc774 \uc124\uce58\ub418\uc5b4 \uc6b4\uc601 \uc911\uc774\ub77c \uac00\uc815\ud558\uc790. Oracle V7.0\uc744 X\ub77c \ud558\uace0 Oracle V7.1\uc744 Y\ub77c\uace0 \ud558\uc790.
\n<\/span><\/p>\n

\u00a7<\/span> Base Compatibility : X\uc758 exp\ub97c \uc774\uc6a9\ud574 X DB\ub97c export\ud558\uc5ec X\uc758 imp\ub97c \uc774\uc6a9\ud574 X DB\uc5d0 import\ud558\ub294 \uac83\uc744 \ub9d0\ud55c\ub2e4. \uc774\ub294 \ub2f9\uc5f0\ud788 \uc9c0\uc6d0\ud55c\ub2e4.
\n<\/span><\/p>\n

\u00a7<\/span> Upward Compatibility : X\uc758 exp\ub97c \uc774\uc6a9\ud574 X DB\ub97c export\ud558\uc5ec Y DB\uc5d0 Y\uc758 imp\ub97c \uc774\uc6a9\ud574 import\ud558\ub294 \uac83\uc744 \ub9d0\ud55c\ub2e4. \uc774\ub3c4 Oracle\uc5d0\uc11c\ub294 \uc9c0\uc6d0\ud55c\ub2e4.
\n<\/span><\/p>\n

\u00a7<\/span> Downward Compatibility : Y exp\ub97c \uc774\uc6a9\ud574 Y DB\ub97c export \ud558\uc5ec X DB\uc5d0 X\uc758 imp\ub85c import\ud558\ub294 \uac83\uc744 \ub9d0\ud55c\ub2e4. \uc774\ub294 \uc9c0\uc6d0\ub420 \uc218\ub3c4 \uc548\ub420 \uc218\ub3c4 \uc788\ub2e4.
\n<\/span><\/p>\n

\u00a7<\/span> Cross Compatibility : X exp\ub97c \uc774\uc6a9\ud574 Y DB\ub97c export (SQL*Net \uc774\uc6a9)\ud558\uc5ec X \ub610\ub294 Y DB\uc5d0 import(imp\ub294 \uc801\uc815\ud55c \uac83\uc744 \ud65c\uc6a9)\ud558\ub294 \uac83\uc744 \ub9d0\ud55c\ub2e4. \uc774\ub294 \uc9c0\uc6d0\ub420 \uc218\ub3c4 \uc548\ub420 \uc218\ub3c4 \uc788\ub2e4.
\n<\/span><\/p>\n

\uc5b4\ub5a4 \uacbd\uc6b0\uc5d0 Downward Compatibility\uac00 \uc2e4\ud328\ud558\ub294\uac00?
\n<\/span><\/h4>\n

V7.2\uc5d0 hash cluster expressions\ub77c\ub294 \uc635\uc158\uc774 \uc788\ub294\ub370, \uc774\ub97c \uc774\uc6a9\ud574\uc11c \ud074\ub7ec\uc2a4\ud130\ub97c \uc0dd\uc131\ud558\uc5ec \uc0ac\uc6a9 \ud6c4 export\ud55c \uac83\uc744 V7.0 \ub610\ub294 V7.1\ub85c downward\uc2dc create cluster\ubb38\uc5d0 \uc635\uc158\uc774 \ub9de\uc9c0\uc54a\uc544 \uc2e4\ud328\ud558\uac8c \ub41c\ub2e4.
\n<\/span><\/p>\n

EXP-37 \uc5d0\ub7ec(export views not compatible with database version) \ubc1c\uc0dd\uc758 \uc6d0\uc778\uc740 \ubb34\uc5c7\uc778\uac00 ?
\n<\/span><\/h4>\n

\uc774 \uc5d0\ub7ec\ub294 Cross Compatibility\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\ub85c \uc774\ub294 Export\uac00 \uc774\uc6a9\ud558\ub294 View(Catexp.sql\uc5d0 \uc758\ud574 \uc0dd\uc131\ub41c)\uac00 Oracle Version\ub0b4\uc5d0 \uc77c\uce58\ud558\uc9c0 \uc54a\uc544 \ubc1c\uc0dd\ud55c \ubb38\uc81c\ub85c \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 Exp\uc5d0\uc11c \uc774\uc6a9 \uac00\ub2a5\ud55c View\ub97c \uc124\uce58\ud55c\ub2e4.
\n<\/span><\/p>\n

Full Export\ub294 Dba \uad8c\ud55c\uc744 \uac16\uace0 \uc788\ub294 \uc720\uc800\ub9cc \ud560 \uc218 \uc788\ub294\uac00 ?
\n<\/span><\/h4>\n

Version 6\uc5d0\uc11c\ub294 DBA\uad8c\ud55c\uc744 \uac16\uace0 \uc788\ub294 \uc774\ub9cc Full Export\ub97c \ud560 \uc218 \uc788\uc73c\uba70, V7\uc5d0\uc11c\ub294 DBA\uac00 \uc544\ub2c8\ub354\ub77c\ub3c4 EXP_FULL_DATABASE Role\uc774 Grant\ub418\uba74 Full Export\uac00 \uac00\ub2a5\ud558\ub2e4.
\n<\/span><\/p>\n

\ud14c\uc774\ube14 Import \uc2dc\uc5d0 \ub514\ud3f4\ud2b8 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 \uc544\ub2cc \uacf3\uc73c\ub85c \ub4e4\uc5b4\uac00\ub294 \uacbd\uc6b0\ub294 \uc65c \ubc1c\uc0dd\ud558\ub294\uac00?
\n<\/span><\/h4>\n

\uc608\ub97c \ub4e4\uc5b4\uc11c scott \uc720\uc800\uc758 \ub514\ud3f4\ud2b8 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uac00 users \uc778\ub370 \uc784\ud3ec\ud2b8\ub97c \ud574\ubcf4\uba74 tools \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ud14c\uc774\ube14\uc774 \ub9cc\ub4e4\uc5b4\uc84c\ub2e4\uace0 \ud558\uc790. \uadf8 \uc774\uc720\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. \uc989, \uc784\ud3ec\ud2b8 \ud558\ub294 \ud14c\uc774\ube14\uc774 \uc6d0\ub798 tools \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \uc788\uc5c8\uace0 scott\uac00 \ud604\uc7ac tools \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c Quota \ub97c \uac00\uc9c0\uace0 \uc788\uac70\ub098 \uc544\ub2c8\uba74 Unlimited Tablespace \uad8c\ud55c(Resource Role \uc5d0 \ud3ec\ud568)\uc744 \ubd80\uc5ec \ubc1b\uc558\uae30 \ub54c\ubb38\uc774\ub2e4.
\n<\/span><\/p>\n

Import\uc2dc\uc5d0 \ud14c\uc774\ube14\uc744 \ub514\ud3f4\ud2b8 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub9cc\ub4e4\ub824\uba74 \ub514\ud3f4\ud2b8 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc678\uc758 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c \ubaa8\ub4e0 Quota\ub97c 0\ub85c \ub9cc\ub4e4\uace0 Unlimited Tablespace \uad8c\ud55c\uc744 Revoke \uc2dc\ud0a8 \ub2e4\uc74c\uc5d0 \uc784\ud3ec\ud2b8\ub97c \uc218\ud589\ud574\uc57c \ud55c\ub2e4. \uadf8\ub9ac\uace0, \ub514\ud3f4\ud2b8 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c Quota\ub9cc Unlimited\ub85c \ud55c\ub2e4. \uc608\ub97c \ub4e4\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.
\n<\/span><\/p>\n

$ sqlplus system\/manager
\n<\/span><\/p>\n

SQL> alter user scott
\n<\/span><\/p>\n

quota 0 on system
\n<\/span><\/p>\n

quota 0 on tools
\n<\/span><\/p>\n

…….
\n<\/span><\/p>\n

quota 0 on data
\n<\/span><\/p>\n

quota unlimited on users;
\n<\/span><\/p>\n

SQL>revoke unlimited tablespace from scott;
\n<\/span><\/p>\n

\uc774\ub807\uac8c \ud55c \ub2e4\uc74c Import\ub97c \uc218\ud589\ud558\uba74 \ub41c\ub2e4. \ubb3c\ub860 \uc720\uc800\ub97c \ub9cc\ub4e4 \ub54c quota\ub97c \uc8fc\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \uc0c1\uad00 \uc5c6\uc73c\uba70 Unlimited Tablespace \uad8c\ud55c(\ub610\ub294 Resource Role) \uc744 \uc8fc\uc9c0 \uc54a\uc558\ub2e4\uba74 Revoke \uba85\ub839\ub3c4 \uc0ac\uc6a9\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4.
\n<\/span><\/p>\n

Import \uc2dc\uc5d0 Core Dump\/Segmentation Fault \uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0
\n<\/span><\/h4>\n

\uc624\ub77c\ud074\uc5d0\ub294 Character Set \uc774\ub77c\uace0 \ud558\ub294 \ubd80\ubd84\uc774 \uc788\ub2e4. \uad6d\ub0b4\uc5d0\uc11c\ub294 US7ASCII \ub610\ub294 KO16KSC5601 \uc744 \uc8fc\ub85c \uc0ac\uc6a9\ud558\ub294\ub370 Export \ubc1b\uc740 \uacf3\uacfc Import \ud558\ub294 \uacf3\uc758 Character Set \uc774 \ub2e4\ub974\uba74 Import \uc2dc\uc5d0 Core Dump \uac00 \ubc1c\uc0dd\ud558\uac70\ub098 \uc6d0\uc778 \ubd88\uba85\uc758 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uba74\uc11c \uc784\ud3ec\ud2b8\uac00 \uc911\ub2e8\ub418\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud55c\ub2e4.
\n<\/span><\/p>\n

\uc774 \uacbd\uc6b0\uc5d0\ub294 Export \ubc1b\uc740 dump file \uc744 convert \ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9\ud558\uc5ec Import \ud558\ub294 \uacf3\uc758 Character Set\uc73c\ub85c \ubcc0\ud658\uc2dc\ud0a8 \ub2e4\uc74c \uc784\ud3ec\ud2b8\ub97c \ud558\ub294 \ubc29\ubc95\uc774 \uc788\uace0, \uc544\ub2c8\uba74 \uc5b4\ub290 \ud55c \ucabd DB \uc758 Character Set \uc790\uccb4\ub97c \ubc14\uafd4\uc11c \ub3d9\uc77c\ud558\uac8c \ub9de\ucd98 \ub2e4\uc74c Export\/Import \ud558\ub294 \ubc29\ubc95\uc774 \uc788\ub2e4. \uc774\uc911\uc5d0\uc11c Convert \ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9\ud558\ub294 \ubc29\ubc95\uc774 \uac04\ub2e8\ud55c\ub370 \uc774 \ud504\ub85c\uadf8\ub7a8\uc740 Unix \uc0c1\uc5d0\uc11c cc\ub85c \ucef4\ud30c\uc77c \ud558\uc5ec\uc11c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \ud504\ub85c\uadf8\ub7a8 \uc18c\uc2a4\ub294 \ucc9c\ub9ac\uc548\uc5d0\uc11c go oracle \ud558\uc5ec \uc815\ubcf4\ubcf4\ubb3c\ucc3d\uace0\uc5d0\uc11c \uad6c\ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

IMPORT\uc2dc Table\uacfc Index\ub97c \ubd84\ub9ac\ud558\uc5ec \uc800\uc7a5\ud558\ub294 \ubc29\ubc95
\n<\/span><\/h4>\n

Export\/Import\ub97c \uc774\uc6a9\ud558\uc5ec Data\ub97c \uc62e\uae30\uac70\ub098 Space\ub97c \uc815\ub9ac\ud560 \ub54c Table\uacfc Index\ub97c \uac01\uac01 \ub2e4\ub978 Tablespace\uc5d0 \ubd84\ub9ac\ud558\uc5ec \uc800\uc7a5\ud558\uae30\ub3c4 \ud55c\ub2e4. \uadf8\ub7ec\ud55c \ubc29\ubc95\uc740 Oracle\uc758 \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ub370 \ub9ce\uc740 \ub3c4\uc6c0\uc744 \uc900\ub2e4.
\n<\/span><\/p>\n

Import\ud560 \ub54c Table\uacfc Index\ub97c \uc0dd\uc131\uc2dc\ucf30\ub358 Script\ub97c \uac00\uc9c0\uace0 \uc788\uc73c\uba74 \ud3b8\ub9ac\ud558\ub2e4.
\n<\/span><\/p>\n

\uba3c\uc800 Import\ud560 \ub54c Indexes=N option\uc744 \uc0ac\uc6a9\ud558\uc5ec Table\ub9cc Import\ud558\uace0, Index\ub294 Script\uc5d0\uc11c Tablespace\ub97c \uc9c0\uc815\ud558\uace0 SQL file\uc744 \uc2e4\ud589\uc2dc\ucf1c\uc11c \uc0dd\uc131\ud558\uba74 \ub41c\ub2e4. \uadf8\ub7ec\ub098 Index Script\ub97c \uac00\uc9c0\uace0 \uc788\uc9c0 \uc54a\uc744 \ub54c\ub294 \ubb38\uc81c\uac00 \ubcf5\uc7a1\ud574\uc9c4\ub2e4.
\n<\/span><\/p>\n

\uadf8\ub7ec\ud55c \uacbd\uc6b0\uc5d0 Import Option\uc911\uc5d0\uc11c Index file Option\uc744 \uc0ac\uc6a9\ud558\uc5ec Index script\ub97c \ub9cc\ub4e4\uc5b4 \ub0bc \uc218\uac00 \uc788\ub2e4. \uc774 \ubc29\ubc95\uc740 Index file\ub9cc \ub9cc\ub4e4\uae30 \ub54c\ubb38\uc5d0 \uc18d\ub3c4\uac00 \ube60\ub974\uace0, Index \ubfd0\ub9cc\uc774 \uc544\ub2c8\ub77c Table Script\ub3c4 \ub9cc\ub4e4\uc5b4 \uc9c0\uae30 \ub54c\ubb38\uc5d0 \uc720\uc6a9\ud558\ub2e4.
\n<\/span><\/p>\n

\ub2e4\uc74c \uc791\uc5c5\uc740 Scott User\uc758 \ubaa8\ub4e0 Data\ub97c Test User\ub85c \uc62e\uae30\uae30 \uc704\ud574\uc11c Export\/Import\ub97c \uc774\uc6a9\ud558\ub824\uace0 \ud55c\ub2e4. Import\uc2dc\uc5d0 Table\uacfc Index\ub294 Tablespace\ub97c \ub2e4\ub974\uac8c \ud558\uc5ec \uc800\uc7a5\ud55c\ub2e4.
\n<\/span><\/p>\n

1. \ub2e4\uc74c\uacfc \uac19\uc774 Scott User\ub97c Export \ubc1b\ub294\ub2e4.
\n<\/span><\/p>\n

$ exp scott\/tiger file=scott.dmp
\n<\/span><\/p>\n

2. Export\ubc1b\uc740 File\uc5d0\uc11c Index\ub97c \uc81c\uc678\ud55c \ub098\uba38\uc9c0\ub9cc Import\ud55c\ub2e4.
\n<\/span><\/p>\n

$ imp system\/manager file=scott.dmp fromuser=scott touser=test indexes=n commit=y
\n<\/span><\/p>\n

\uc704\uc640 \uac19\uc774 \uc2e4\ud589\ud558\uba74 Test User\uc5d0\ub294 Index\ub97c \uc81c\uc678\ud55c \ub098\uba38\uc9c0 Object\ub9cc Import\ub41c\ub2e4.
\n<\/span><\/p>\n

3. \uadf8\ub9ac\uace0 \ub2e4\uc74c\uacfc \uac19\uc774 Indexfile Option\uc744 \uc774\uc6a9\ud558\uc5ec Index Script\ub97c \ub9cc\ub4e0\ub2e4.
\n<\/span><\/p>\n

$ imp system\/manager file=scott.dmp indexfile=index.sql
\n<\/span><\/p>\n

\uc704\uc640 \uac19\uc774 \uba85\ub839\uc744 \uc2e4\ud589\ud558\uba74 index.sql\uc774\ub77c\ub294 File\uc774 \ub9cc\ub4e4\uc5b4\uc9c4\ub2e4. \uadf8\ub9ac\uace0 \uadf8 \ud654\uc77c\uc744 VI \ub4f1\uc73c\ub85c \uc5f4\uc5b4\uc11c \ud655\uc778\ud574 \ubcf4\uba74 create table \ubb38\uc7a5\uacfc create index\ubb38\uc7a5\uc774 \uc788\uace0 Create Table \ubb38\uc7a5\uc740 REM\uc73c\ub85c \ub9c9\ud600 \uc788\uc5b4\uc11c \uacb0\uacfc\uc801\uc73c\ub85c Create Index\ubb38\ub9cc \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ub418\uc5b4 \uc788\ub2e4.
\n<\/span><\/p>\n

\uc774 \ud654\uc77c\uc5d0\uc11c Create Index\ubb38\uc758 Tablespace\ub9cc \ubc14\uafb8\uc5b4\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 SQL*Plus\uc5d0\uc11c \uc2e4\ud589\uc2dc\ud0a8\ub2e4.
\n<\/span><\/p>\n

$ sqlplus test\/test
\n<\/span><\/p>\n

SQL> @index
\n<\/span><\/p>\n

\uc774\ub807\uac8c \ud558\uc5ec Table\uacfc Index\ub97c \ub2e4\ub978 Tablespace\ub85c \ubd84\ub9ac\ud558\uc5ec \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

\uc774 Indexfile option\uc740 Index\ub9cc\uc774 \uc544\ub2c8\ub77c Table \uc0dd\uc131 \ubb38\uc7a5\uc774 \ud544\uc694\ud560 \ub54c\ub3c4 \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud558\uc5ec \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

Export\uc2dc\uc5d0 Export File \uc555\ucd95\ud558\ub294 \ubc29\ubc95
\n<\/span><\/h4>\n

1. Root\uc5d0\uc11c \uba3c\uc800 NAMED PIPE\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

# mknod \/dev\/PIPE.dmp p
\n<\/span><\/p>\n

2. Oracle Home\uc73c\ub85c login\ud558\uc5ec Export Script\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

$ vi compress_exp
\n<\/span><\/p>\n

nohup exp system\/manager full=y compress=y file=\/dev\/PIPE.dmp &
\n<\/span><\/p>\n

compress < \/dev\/PIPE.dmp > \/user\/expfull.z &
\n<\/span><\/p>\n

3. Export \uc2e4\ud589\uacfc Log \ud655\uc778
\n<\/span><\/p>\n

$ compress_exp
\n<\/span><\/p>\n

$ tail – f nohup.out
\n<\/span><\/p>\n

4. Import Script \ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

$ vi uncompress_exp –
\n<\/span><\/p>\n

uncompress < \/user\/expfull.z > \/dev\/PIPE.dmp &
\n<\/span><\/p>\n

nohup imp system\/manager file=\/dev\/PIPE.dmp commit=y &
\n<\/span><\/p>\n

5. Import \uc2e4\ud589\uacfc Import Log\uc758 \ud655\uc778
\n<\/span><\/p>\n

$ uncompress_exp \uc2e4\ud589
\n<\/span><\/p>\n

$ tail -f nohup.out
\n<\/span><\/p>\n

Import
\n<\/span><\/h3>\n

DATA IMPORT \ub294 EXPORT\ub41c file\uc744 \uc774\uc6a9\ud558\uc5ec database\ub97c \ubcf5\uad6c\ud558\ub294 \uc791\uc5c5\uc744 \ub9d0\ud55c\ub2e4. \ud56d\uc0c1 EXPORT \ub41c FILE \ub85c\ub9cc IMPORTING\uc774 \ub41c\ub2e4.
\n<\/span><\/p>\n

Import \uc791\uc5c5 Test
\n<\/span><\/h3>\n

\uc804\uccb4 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 EXPORT FILE\ub85c\ubd80\ud130 SINGLE TABLE \uc744 IMPORT (INTERACTIVE MODE)
\n<\/span><\/h4>\n

$ imp system\/manager
\n<\/span><\/p>\n

Connected to: ORACLE7 Server Release 7.0.16.4.0 – Production
\n<\/span><\/p>\n

With the procedural and distributed options
\n<\/span><\/p>\n

PL\/SQL Release 2.0.18.1.0 – Production
\n<\/span><\/p>\n

Import file: expdat.dmp > (RETURN)
\n<\/span><\/p>\n

Enter insert buffer size (minimum is 4096) 30720 > (RETURN)
\n<\/span><\/p>\n

Export file created by EXPORT:V07.00.16
\n<\/span><\/p>\n

List contents of import file only (yes\/no) : no > “yes” \uc774\uba74 data\ub294 import \ub418\uc9c0\uc54a\uace0 Display \ub9cc \ub428
\n<\/span><\/p>\n

Ignore create errors due to object existence (yes\/no) : yes > (“yes” : \ub9cc\uc77c table\uc774 \uc874\uc7ac\ud558\uba74
\n<\/span><\/p>\n

record \uac00 \ucd94\uac00\ub41c\ub2e4. “no” : \uc774\ubbf8 \uc874\uc7ac\ud55c
\n<\/span><\/p>\n

Object\uc5d0 \ub300\ud574\uc11c import\ub97c \ud558\uc9c0\uc54a\ub294\ub2e4.)
\n<\/span><\/p>\n

Import grants (yes\/no) : yes >
\n<\/span><\/p>\n

Import table data (yes\/no) : yes >
\n<\/span><\/p>\n

Import entire export file (yes\/no) : yes > no
\n<\/span><\/p>\n

User name : SCOTT
\n<\/span><\/p>\n

Enter table name. Null list name all tables for user
\n<\/span><\/p>\n

Enter table name or . if done : TEST
\n<\/span><\/p>\n

importing SCOTT’s objects into SCOTT
\n<\/span><\/p>\n

importing table TEST 900 rows imported
\n<\/span><\/p>\n

Import terminated successfully.
\n<\/span><\/p>\n

\uc8fc\uc758 : IMPORT \uc791\uc5c5\uc740 \ubcf4\ud1b5 \uc0dd\uc131\ub418\ub294 INDEX \uc218\uc5d0 \ub530\ub77c 1.5 – 4 \ubc30\uc758 \uc2dc\uac04\uc774 \uac78\ub9ac\ub294\ub370 EXPORT \ub294 “CREATE INDEX ….” \ubb38\ub9cc\uc744 FILE\uc5d0 \uc4f0\uace0 IMPORT \uc2dc\uc5d0\ub294 INDEX\ub97c \uc0dd\uc131\ud558\uae30 \ub54c\ubb38\uc774\ub2e4.
\n<\/span><\/p>\n

\uc804\uccb4 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 EXPORT FILE \ub85c\ubd80\ud130 SINGLE TABLE \uc744 IMPORT (OMMAND LINE MODE)
\n<\/span><\/h4>\n

$ imp system\/manager full=n grants=y rows=y tables=test commit=y
\n<\/span><\/p>\n

\uc8fc\uc758 : IMPORT \uc2dc\ub294 \ub370\uc774\ud0c0\ub97c DB \uc5d0 WRITE \ud558\uae30 \ub54c\ubb38\uc5d0 ROLLBACK SEGMENT\uac00 \uc0ac\uc6a9\ub41c\ub2e4. commit=y \ub294 row \ub9cc\ud07c \ub370\uc774\ud0c0\ub97c LOAD \ud558\uace0 \ub098\uc11c COMMIT \uc744 \ud558\uae30 \ub54c\ubb38\uc5d0 ROLLBACK SEGMENT \uac00 \ucee4\uc9c0\ub294 \uac83\uc744 \ud53c\ud560 \uc218 \uc788\ub2e4. commit=n \uc774\uba74 TABLE \ub2e8\uc704\ub85c IMPORT \ud558\uace0 \ub098\uc11c COMMIT \uc774 \ub418\uae30 \ub54c\ubb38\uc5d0 ROLLBACK SEGMNET \ud655\uc7a5 ERROR \uac00 \ubc1c\uc0dd \ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

INCREMENTAL IMPORTING
\n<\/span><\/h4>\n

EXPORT \ub41c FILE \uc774 \ub2e4\uc74c\uacfc \uac19\ub2e4\uace0 \ud558\uba74
\n<\/span><\/p>\n

F : full C : cumulative I : incremental
\n<\/span><\/p>\n

F1, I1, I2, C1, I3, I4, C2, I5, I6
\n<\/span><\/p>\n

1. \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \ub2e4\uc2dc \uc0dd\uc131\ud55c\ub2e4.(CREATE DATABASE \ubb38\uc7a5\uc744 \uc0ac\uc6a9)
\n<\/span><\/p>\n

2. IMPORT \ud558\uae30 \uc704\ud574 \ucda9\ubd84\ud55c ROLLBACK SEGMENT\ub97c \ucd94\uac00\ud55c\ub2e4.
\n<\/span><\/p>\n

3. \uac00\uc7a5 \ucd5c\uadfc KEY \uc815\ubcf4\ub97c IMPORT \ud55c\ub2e4.
\n<\/span><\/p>\n

$ imp system\/manager inctype=SYSTEM full=y file=I6
\n<\/span><\/p>\n

4. \uac00\uc7a5 \ucd5c\uadfc COMPLETE\ub85c EXPORT \ud55c FILE \uc744 IMPORT \ud55c\ub2e4.
\n<\/span><\/p>\n

$ imp system\/manager inctype=RESTORE full=y file=F1
\n<\/span><\/p>\n

5. \ubaa8\ub4e0 CUMULATIVE IMPORT\ub97c \uc21c\uc11c\uc801\uc73c\ub85c \uc2e4\ud589\ud55c\ub2e4.
\n<\/span><\/p>\n

$ imp system\/manager inctype=restore full=y file=C1
\n<\/span><\/p>\n

$ imp system\/manager inctype=restore full=y file=C2
\n<\/span><\/p>\n

6. INCREMENTAL IMPORT\ub97c \uc21c\uc11c\uc801\uc73c\ub85c \uc2e4\ud589\ud55c\ub2e4.
\n<\/span><\/p>\n

$ imp system\/manager inctype=restore full=y file=I5
\n<\/span><\/p>\n

$ imp system\/manager inctype=restore full=y file=I6
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Export & Import EXPORT \ub294 DATA\ub97c ORACLE DATABASE\ub85c\ubd80\ud130 ORACLE Binary \ud615\ud0dc\uc758 OS FILE\ub85c \ub9cc\ub4e4\uace0 IMPORT\ub97c \uc774\uc6a9\ud558\uc5ec DATABASE\ub85c LOADING \ud55c\ub2e4. Export ORACLE DATABASE\ub97c OS file\ub85c \ub9cc\ub4dc\ub294 \uc791\uc5c5\uc774\ub2e4. \uc774 \uc791\uc5c5\uc740 DATABASE\uac00 OPEN \ub418\uc5b4\uc788\ub294 \ub3d9\uc548\uc5d0 \uc2e4\uc2dc \ud560 \uc218 \uc788\ub2e4. EXPORT MODE Export \uc791\uc5c5\uc744 \uc218\ud589 \ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc73c\ub85c\ub294 \uc544\ub798\uc758 3\uac00\uc9c0 \ubc29\ubc95\uc73c\ub85c \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4. USER \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc5b4\ub5a4 \uc720\uc800\uc18c\uc720\uc758 \ubaa8\ub4e0 […]<\/p>\n","protected":false},"author":1,"featured_media":2862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[10],"tags":[116,863,1052,1053,1055,1056,1054,865],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/managed-services2.jpg?fit=1200%2C386","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3640"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3640"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3640\/revisions"}],"predecessor-version":[{"id":3642,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3640\/revisions\/3642"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2862"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3640"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}