Where is the dump of an export located in an Oracle 9i export?

A SearchOracle.com reader asks, "Where is the dump of an export located in an Oracle 9i export?"

Brian Peasland

Published: 02 Jan 2008

When you run the Oracle export utility, you can specify the dump file name and location with the FILE parameter, similar to the following:

exp userid=system/manager file=/directory/my_dump.dmp ……

If you do not specify the directory for your dump file, Oracle will create the dump file in your current directory. If you omit the FILE parameter, the exp utility will default to creating a dump file called "expdat.dmp."

Dig Deeper on Oracle database administration

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

SearchDataManagement

Ahana brings PrestoDB SQL query engine to the cloud

Soon after announcing its seed round of funding, Ahana launched commercial support services for the open source federated SQL ...

Confluent enables infinite Kafka scalability in the cloud

Kafka gets data retention boost that can make it easier for users to store event streaming data for long periods of time, which ...

Fivetran raises $100M to advance enterprise data integration

The co-founder and CEO of Fivetran talks about what the vendor is doing to help organizations meet the challenges of enterprise ...

SearchBusinessAnalytics

Overcoming the top 3 analytics adoption challenges

Analytics is a growing part of many businesses. Experts talk about some of the most pressing challenges enterprises may face when...

More AI, ease of use will shape Sisense analytics platform

After spending three years at Alteryx most recently, Ashley Kramer is now Sisense's new chief product officer. In an interview, ...

Lack of data literacy still a problem for many organizations

Organizations' lack of confidence in their ability to understand and use data to make decisions blocks their efforts to become ...

SearchSAP

SAP Cloud Platform apps deal with pandemic problems

SAP Cloud Platform is proving to be a useful development environment for applications that address issues brought on by the ...

7 SAP S/4HANA implementation issues to address

A move to S/4HANA is critical for SAP users, but getting it right is difficult. Here's a look at seven issues to address.

SAP for Me provides 'one-stop shopping' for product data

Customers who need comprehensive information about their SAP environments can now use the new SAP for Me portal to get a complete...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

3 ways a volunteer programmer can help in a pandemic

DevOps pros can help local and state agencies battle COVID-19. Here are three ways they can volunteer their time during a ...

Oracle's release cadence opens door for Java support rivals

Oracle has opened the door for competitors to chip away at its hold on the market for providing Java support to enterprise ...

Dojo Toolkit 7 focuses on JavaScript developer productivity

Dojo Toolkit version 7 is now available. The widely used, mature JavaScript framework favored by enterprise shops gains more ...

SearchDataCenter

An introduction to DCIM software metrics and terms

Infrastructure management is no easy task. The right software can help admins track how efficient their server racks and ...

6 steps to prep your organization for ISO 9001 certification

ISO 9001 is a quality management standard. Before your team decides to become certified with an official audit, you should have ...

Honeywell touts quantum computer speed, but how fast is fast?

Honeywell has delivered what it believes is the industry's fastest quantum computer. But analysts say it will take more than ...

SearchContentManagement

Microsoft products address digital workplace security

Microsoft is enhancing products with additional features to address content security, enabling businesses to minimize risks while...

Why version control is necessary in digital asset management

Version control is essential to DAM systems, as it enables multiple iterations of documents and rich media while retaining the ...

How to use social networking CMS to create social media sites

Whether a company uses its own social CMS or a vendor's platform to create a social media site, it offers more features to users ...

SearchHRSoftware

Feds nix college degree requirement for merit-based hiring

President Trump has ordered federal agencies, which employ 2.2 million, to move to merit-based hiring by the end of the year. ...

HR software selection: How to ask the right questions

Finding the right software isn't just a one-stop shop. You'll need to ask the right questions before determining the HR software ...

Workday admits to Black diversity problem, pledges to improve

Workday makes HR tools, including diversity software, for half of the Fortune 100. But Black employees make up less than 3% of ...

Dig Deeper on Oracle database administration

Taking export for all schemas

How to export data by date in Oracle

How to export table from one Oracle database to another

How to import/export Oracle dump file from Windows to Solaris

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.