Exp/imp use

[SQL]View Plaincopy

2. 1. EXP:
6. 1. Complete:
8. EXP System/manager buffer=64000 file=c:\full. DMP full=y
10. If you want to perform a full export, you must have special permissions
14. 2. User mode:
16. EXP sonic/sonic buffer=64000 file=c:\sonic. DMP Owner=sonic
18. This allows all objects that the user sonic to be exported to a file.
24. 3. Table mode:
26. EXP sonic/sonic buffer=64000 file=c:\sonic. DMP owner=sonic tables= (SONIC)
28. This way the user Sonic table Sonic is exported
32. Exp parameter:
34. Keyword description (default)
36. ———————————————-
38. UserID username/Password
40. full export of the entire file (N)
42. Size of buffer data buffers
44. Owner User Name list
46. File output files (expdat. DMP)
48. List of TABLES table names
50. COMPRESS Importing a range (Y)
52. Length of RecordLength IO record
54. GRANTS Export Permissions (Y)
56. Inctype Incremental Export Type
58. INDEXES Export Index (Y)
60. RECORD Tracking Incremental Export (Y)
62. Rows Export Data rows (Y)
64. Parfile parameter file name
66. CONSTRAINTS Export Limit (Y)
68. Consistent cross-table consistency
70. Log file on screen output
72. STATISTICS Analysis Object (ESTIMATE)
74. Direct Path (N)
76. TRIGGERS Export Trigger (Y)
78. FEEDBACK shows the progress of each x line (0)
80. FILESIZE maximum size of each dump file
82. QUERY selects the clause that exports a subset of tables
86. 2. IMP:
90. Three modes (full, user, table)
94. 1. Complete:
96. IMP System/manager buffer=64000 file=c:\full. DMP full=y
100. 2. User mode:
102. IMP sonic/sonic buffer=64000 file=c:\sonic. DMP Fromuser=sonic Touser=sonic
104. This allows all objects sonic by the user to be imported into the file. You must specify the Fromuser, touser parameter so that data can be imported.
108. 3. Table mode:
110. EXP sonic/sonic buffer=64000 file=c:\sonic. DMP owner=sonic tables= (SONIC)
112. This way the user Sonic table Sonic is imported.
116. Imp Parameters:
118. Keyword description (default)
120. ———————————————-
122. UserID username/Password
124. full import of entire file (N)
126. Buffer size of data buffers
128. Fromuser Owner User Name list
130. File input files (expdat. DMP)
132. Touser List of user names
134. SHOW only lists file contents (N)
136. List of TABLES table names
138. IGNORE Ignore Create error (N)
140. Length of RecordLength IO record
142. GRANTS Import Permissions (Y)
144. Inctype Incremental Import Type
146. INDEXES Import Index (Y)
148. Commit Commit array Insert (N)
150. Rows Import data rows (Y)
152. Parfile parameter file name
154. Log file on screen output
156. CONSTRAINTS Import Limit (Y)
158. DESTROY Overlay tablespace data file (N)
160. Indexfile Writing table/index information to the specified file
162. Skip_unusable_indexes Skip maintenance of indexes that are not available (N)
164. ANALYZE executing the ANALYZE statement in the dump file (Y)
166. FEEDBACK shows the progress of each x line (0)
168. Toid_novalidate skips a checksum of the specified type ID
170. FILESIZE maximum size of each dump file
172. Recalculate_statistics recalculation of statistical values (N)

Exp/imp use