
	Home > Ask the Oracle Experts > Database Backup and Recovery Questions & Answers > Importing a dump file

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Importing a dump file

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 17 September 2004
I am just starting to learn Oracle 9i. I have gotten one 'db999992003.dmp' file but i can't import this file. Please give your full advice what I should do, and I want full SQL.

EXPERT RESPONSE

To import the contents of this dump file, you will have to use Oracle's import utility. There is no SQL statement that will do what you ask. You did not explain your difficulties in importing the contents of this dump file. But the basic import call will look similar to the following:

imp userid=system/manager file=db999992003.dmp full=y log=imp.log

I always log the output to a file so that I can go back and ensure that I did not have any problems.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Importing and restoring databases
	Database storage management with Independent Oracle Users Group president Ari Kaplan - Podcast
	Database down! Bring it back alive!
	Recover Oracle databases
	Recovering crashed database with corrupted undo tablespace
	Restoring database on test machine
	Advice on Oracle disaster recovery plan
	Necessary privileges for importing a .dmp file
	Testing offline backup by restoring files to remote site
	Recovering 9i database when current online redo log is lost
	Importing Windows 2000 backup file into Solaris OS

Database Backup and Recovery

Is a hot backup part of a backup database using RMAN?

How does Oracle instance recovery work and what happens internally?

How to back up Oracle 10g RAC database on an AIX system

How to configure Oracle DB_BLOCK_SIZE and Solaris operating system block size

Tips for using parameters in an Oracle dump file import

Which backup strategy should I use for my Oracle 10g database?

RMAN catalog backup: One catalog vs. multiple catalogs

Can I use Oracle FTP for importing data from Oracle 11g into 10g?

When to use the Oracle ANALYZE command and how to avoid complications

How to complete an Oracle installation on Linux

Oracle database backup and recovery

Oracle OpenWorld 2008 Special Report

Oracle 11g: Backup and recovery concepts

Weighing remote database administration pros and cons takes care

Data retention policy for Oracle DBAs: When to "trash" your data

Case study: Oracle RMAN improves backup and recovery efficiency in a multi-platform, multi-application environment

How do I do that in Oracle?

Oracle and the rise of the virtual machine

Oracle 11g data compression

Oracle OpenWorld 2007 Special Report

Hierarchical storage management for database growth, part 1

Oracle database backup and recovery Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy