|
1. What is correct command line in importing a dump file?
Dan Norris: Imp
2. Where should I import, or in what location should I be when importing a dump file? Is within root# location OK to immediately execute the import command?
Dan Norris: It does not matter what your present working directory (pwd) is when doing
an import. It also does not matter what OS user you're currently logged in
as. What matters is whether the OS user can read the dump file and that the
database user you use when importing has proper privileges.
3. What are the necessary or important things to do/check/configure before importing the dump file?
Dan Norris: I always precreate table spaces manually to ensure that I know where the
Data files will be; if you're importing some users or objects that already
exist, use "ignore=y" or answer "yes" when asked if you want to ignore error
messages due to objects that already exist; make sure that the database has
sufficient space to hold the dump file contents; if you're archiving, ensure
that your archive log destination is large enough to handle the additional
logs generated by the import.
4. How can I validate or know if the importing procedure is correct or okay?
Dan Norris: When importing, you can specify a logfile with the "log=/path/to/file.log"
argument. Check that log for any errors. The errors will also be reported to
the screen, so you can also use the UNIX utility "script" to save the screen
contents to a file and check that later.
Maybe you should consider hiring a DBA or going to some training. Using
export and import are concepts taught in most entry-level DBA classes. They
are easy utilities to use, but, like everything, it's best to know how to use
them before attempting to do so.
We really need to commence the activity immediately before anything bad happens to our database server.
Dan Norris: Maybe you should consider hiring a DBA or going to some training. Using
export and import are concepts taught in most entry-level DBA classes. They
are easy utilities to use, but, like everything, it's best to know how to use
them before attempting to do so.
|
