Database Reference
In-Depth Information
database and will import the data from external binary file to
your schema.
Username: system
Password: manager
Step 3: Answer questions asked by Import Utility
Following questions will be asked by import utility and most of
them are self-explanatory. The very first prompt would be the
name of file you would like to import into your Oracle schema.
Over here provide the full qualified dump file name i.e. file
name as well as path where it is located.
Import file: expdata.dmp> emp.dmp
Similarly as with Export utility, the Import utility will ask for the
buffer size. We are choosing 8K the minimum one.
Enter insert buffer size (minimum is 8192) 30720 > 8192
Next, the utility asks for whether to list the contents of the dump
file or not. The default is no, which will do the import without
listing the contents. Choose the default i.e. no.
List contents of import file only (yes/no): no> n
Next prompt would be as follows and it asks for whether to
ignore the CREATE ERROR if the object already exits. Choose
yes.
Ignore create error due to object existence (yes/no): no> y
The next question as for whether to import grants related to
object that we are trying to import.
Import grants (yes/no): yes > y
Search WWH ::
Custom Search