أسترجاع ملف dmp

عن طريق IMP

IMP USERID=USER/PASSWARD@STRING FILE=C:MYFILE.DMP FULL=Y

USERID هي المستخدم وكلمة السر واسم قاعدة البيانات

FILE موقع الملف

FULL هل تريد استرجاع قاعدة البيانات كاملة اذا كان تم اخذ EMP لكامل قاعدة البيانات

واذا كان ملفات محددة فيوضع بدل FULL كلمة TABLES= وتوضع اسماء الملفات بينها COMMA

هذا بشكل مبسط لعمل امبورت لكامل قاعدة البيانات والتفصيل كله في هذه الاسطر

Import Utility Parameters

Like the Export utility, the Import utility uses the following parameters to control its behavior:

· USERID: specifies the name and password of the user who will do the export (must have dba privilege)

USERID=system/manager

· BUFFER: specifies the size of the data buffer for the export run:

BUFFER=8192

Usually, larger the buffer the faster the export will run. As a rule of thumb, this value should be 10% of the operating system’s memory

· FILE: specifies the name of the input file and can contain a directory path to tell Import where to find the file:

FILE=d:oradatabackupprd021499.dmp

· GRANTS: if set to y, it imports the granted privileges on imported objects

GRANTS=y

· INDEXES: if set to y, it imports the indexes associated to the tables being imported

INDEXES=n

· ROWS: if set to y, it imports the data

ROWS=y

· FULL: if set to y, the entire inputfile is imported; if set to n, it results in user level import if table names are not specified in the table parameter

FULL=y

· TABLES: if specified, performs a table-level imports for all the tables specified

TABLES=sku,lot,loc

· FEEDBACK: if specified with a number greater than zero, it displays a dot whenever the number of rows imported equal to that number.

FEEDBACK=100

· INDEXFILE: if specified, creates a file with index-creation commands generated by the Import utility

· DESTROY: if specified, creates the tablespace with reuse specified for the existing datafile. This process re-creates all the tablespaces and removes the segments that reside in them.

DESTROY=n

· LOG: specifies the name of the file that contains all the messages about the import

LOG= d:oradatabackupprd021499.log

· RECORD: if set to y, it records whether the export was incremental or cumulative

RECORD=y

· HELP: if set to y, it shows all valid parameters for the export

HELP=n

· PARFILE: specifies the name of the parameter file

PARFILE= d:oradatabackupprd_parfile

· FROMUSER: if specified, causes Import to create and load the data to the USERID specified.

IMP73 USERID=forte/forte FROMUSER=tony FILE=expdat.dmp

· TOUSER: if specified, causes an object exported by one user to be imported to another user

IMP73 USERID=forte/forte FROMUSER=tony TOUSER=scott FILE=expdat.dmp

· INCTYPE: specifies incremental import types (complete, cumulative and incremental)

INCTYPE=complete

شكراً جزيلاً يا أخي و جازاك الله خيراً