how to import .dmp file in oracle database by command prompt

Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

5.02k DBMS_OUTPUT.PUT_LINE not print

3.02k how to import .dmp file in ora

2.27k Single Row Function in Oracle

1.36k Selecting the first n rows, Pa

1.27k How to check Null/WhiteSpaces/

1.14k Aggregate Functions

prev 1 2 3 … 6 next

how to import .dmp file in oracle database by command prompt

@GAGANDEEPSINGH

Follow Recommendations Offline Message

over 9 years ago
- 0
- 1
  Positive Vote
- 1
  Negative Vote
- 1
  Save Favourite
- 1
- 0
- 0
- 0
- 3.02k
Comment on it
login as dba

SYNTAX-- imp userid/password@database_name file='path of dmp file' full=y

e.g- imp system/manager@orcl file='c:\dabasefile.dmp' full=y

Tags
gagan

Comment on it

1 Comment(s)

@amolgotmare777

Follow Recommendations Offline Message

almost 7 years ago
- 0
- 0
- 0
  Report spam
- 0
- 0
imp system/manager@orcl file='c:\dabasefile.dmp' full=y
this procedure is very slow importing dump file please help

Sign In

Create an account !!

OR

Register

Sign up using

OR

^* Email

^* Please enter email address ^* Please enter a valid email ^* E-mail already exists ^* Sorry, this domain is blacklisted

^* User Name

^* Email

^* Email confirmation

^* Password

^* Password confirmation

Forgot Password

Fill out the form below and instructions to reset your password will be emailed to you:

Reset Password

Fill out the form below and reset your password:

Hire
Post Projects
Browse Nerds
Work
Find Projects Find Projects
- UI Design and UX
  - 3D max
  - |
  - CSS
  - |
  - Flash
  - |
  - Html
  - |
  - Illustrator
  - |
  - Maya
  - |
  - Photoshop
  - |
  - UI Design
  - |
  - UX
- Software Engineering
  - .Net
  - |
  - Android
  - |
  - Angular
  - |
  - Apache
  - |
  - AS3
  - |
  - Automation
  - |
  - AWS
  - |
  - Azure
  - |
  - C
  - |
  - C++
  - |
  - CakePHP
  - |
  - Cloud Computing
  - |
  - CMS
  - |
  - CodeIgniter
  - |
  - Docker
  - |
  - DotNetNuke
  - |
  - Drupal
  - |
  - Flex
  - |
  - GIT
  - |
  - Google Cloud
  - |
  - Informatica
  - |
  - Ionic
  - |
  - iOS
  - |
  - JAVA
  - |
  - Javascript
  - |
  - Kubernetes
  - |
  - Laravel
  - |
  - Liferay
  - |
  - Linux
  - |
  - Mac OS
  - |
  - Magento
  - |
  - Manual Testing
  - |
  - MongoDB
  - |
  - MySQL
  - |
  - NativeScript
  - |
  - Networking
  - |
  - Node.js
  - |
  - NoSQL
  - |
  - Objective C
  - |
  - OpenERP
  - |
  - Oracle
  - |
  - Phalcon
  - |
  - PhoneGap
  - |
  - PHP
  - |
  - PostgreSQL
  - |
  - Python
  - |
  - Qt
  - |
  - React
  - |
  - React Native
  - |
  - Ruby
  - |
  - Security Testing
  - |
  - SharePoint
  - |
  - Site Testing
  - |
  - SQL
  - |
  - Swift
  - |
  - Symfony
  - |
  - Unity3D
  - |
  - Version Control
  - |
  - Visual Studio
  - |
  - Windows
  - |
  - Windows Mobile
  - |
  - Wordpress
  View more...
  
  View less...
- Marketing
  - Blogging
  - |
  - Digital Marketing
  - |
  - SEO & Growth Hacking
  - |
  - Social Media
- General
  - Agile
  - |
  - Findnerd Updates
  - |
  - Gadgets
  - |
  - Game Development
  - |
  - General
  - |
  - Mobile Development
  - |
  - SCRUM
  - |
  - Technology
  - |
  - Web Development
  View more...
  
  View less...
- Business
  - Business Intelligence
  - |
  - Entrepreneurs
  - |
  - Freelancing
  - |
  - Product Development
  - |
  - Project Management
  - |
  - Startups
Manage
Company Company
Learn
Nerd Digest Nerd Digest
- UI Design and UX
  - 3D max
  - |
  - CSS
  - |
  - Flash
  - |
  - Html
  - |
  - Illustrator
  - |
  - Maya
  - |
  - Photoshop
  - |
  - UI Design
  - |
  - UX
- Software Engineering
  - .Net
  - |
  - Android
  - |
  - Angular
  - |
  - Apache
  - |
  - AS3
  - |
  - Automation
  - |
  - AWS
  - |
  - Azure
  - |
  - C
  - |
  - C++
  - |
  - CakePHP
  - |
  - Cloud Computing
  - |
  - CMS
  - |
  - CodeIgniter
  - |
  - Docker
  - |
  - DotNetNuke
  - |
  - Drupal
  - |
  - Flex
  - |
  - GIT
  - |
  - Google Cloud
  - |
  - Informatica
  - |
  - Ionic
  - |
  - iOS
  - |
  - JAVA
  - |
  - Javascript
  - |
  - Kubernetes
  - |
  - Laravel
  - |
  - Liferay
  - |
  - Linux
  - |
  - Mac OS
  - |
  - Magento
  - |
  - Manual Testing
  - |
  - MongoDB
  - |
  - MySQL
  - |
  - NativeScript
  - |
  - Networking
  - |
  - Node.js
  - |
  - NoSQL
  - |
  - Objective C
  - |
  - OpenERP
  - |
  - Oracle
  - |
  - Phalcon
  - |
  - PhoneGap
  - |
  - PHP
  - |
  - PostgreSQL
  - |
  - Python
  - |
  - Qt
  - |
  - React
  - |
  - React Native
  - |
  - Ruby
  - |
  - Security Testing
  - |
  - SharePoint
  - |
  - Site Testing
  - |
  - SQL
  - |
  - Swift
  - |
  - Symfony
  - |
  - Unity3D
  - |
  - Version Control
  - |
  - Visual Studio
  - |
  - Windows
  - |
  - Windows Mobile
  - |
  - Wordpress
  View more...
  
  View less...
- Marketing
  - Blogging
  - |
  - Digital Marketing
  - |
  - SEO & Growth Hacking
  - |
  - Social Media
- General
  - Agile
  - |
  - Findnerd Updates
  - |
  - Gadgets
  - |
  - Game Development
  - |
  - General
  - |
  - Mobile Development
  - |
  - SCRUM
  - |
  - Technology
  - |
  - Web Development
  View more...
  
  View less...
- Business
  - Business Intelligence
  - |
  - Entrepreneurs
  - |
  - Freelancing
  - |
  - Product Development
  - |
  - Project Management
  - |
  - Startups
Tech Q & A Tech Q & A
- UI Design and UX
  - 3D max
  - |
  - CSS
  - |
  - Flash
  - |
  - Html
  - |
  - Illustrator
  - |
  - Maya
  - |
  - Photoshop
  - |
  - UI Design
  - |
  - UX
- Software Engineering
  - .Net
  - |
  - Android
  - |
  - Angular
  - |
  - Apache
  - |
  - AS3
  - |
  - Automation
  - |
  - AWS
  - |
  - Azure
  - |
  - C
  - |
  - C++
  - |
  - CakePHP
  - |
  - Cloud Computing
  - |
  - CMS
  - |
  - CodeIgniter
  - |
  - Docker
  - |
  - DotNetNuke
  - |
  - Drupal
  - |
  - Flex
  - |
  - GIT
  - |
  - Google Cloud
  - |
  - Informatica
  - |
  - Ionic
  - |
  - iOS
  - |
  - JAVA
  - |
  - Javascript
  - |
  - Kubernetes
  - |
  - Laravel
  - |
  - Liferay
  - |
  - Linux
  - |
  - Mac OS
  - |
  - Magento
  - |
  - Manual Testing
  - |
  - MongoDB
  - |
  - MySQL
  - |
  - NativeScript
  - |
  - Networking
  - |
  - Node.js
  - |
  - NoSQL
  - |
  - Objective C
  - |
  - OpenERP
  - |
  - Oracle
  - |
  - Phalcon
  - |
  - PhoneGap
  - |
  - PHP
  - |
  - PostgreSQL
  - |
  - Python
  - |
  - Qt
  - |
  - React
  - |
  - React Native
  - |
  - Ruby
  - |
  - Security Testing
  - |
  - SharePoint
  - |
  - Site Testing
  - |
  - SQL
  - |
  - Swift
  - |
  - Symfony
  - |
  - Unity3D
  - |
  - Version Control
  - |
  - Visual Studio
  - |
  - Windows
  - |
  - Windows Mobile
  - |
  - Wordpress
  View more...
  
  View less...
- Marketing
  - Blogging
  - |
  - Digital Marketing
  - |
  - SEO & Growth Hacking
  - |
  - Social Media
- General
  - Agile
  - |
  - Findnerd Updates
  - |
  - Gadgets
  - |
  - Game Development
  - |
  - General
  - |
  - Mobile Development
  - |
  - SCRUM
  - |
  - Technology
  - |
  - Web Development
  View more...
  
  View less...
- Business
  - Business Intelligence
  - |
  - Entrepreneurs
  - |
  - Freelancing
  - |
  - Product Development
  - |
  - Project Management
  - |
  - Startups
Ask Tech Query
Post Blogs