Q
Problem solve Get help with specific problems with your technologies, process and projects.

Migrating data to a remote server

I really need to migrate the data on a remote server and have a few questions.

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.

This was last published in December 2004

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close