Recently in the use of Oracle import a DMP file, because you do not know how the DMP file is exported, using exp or EXPDP export, so tangled up a relatively long time, finally thought can see the DMP file some auxiliary information, so have this tool.
The following error was reported when using DMP Import
IMP-00010:
Win7 System can not open DMP file how to do? blue screen Problem I believe everyone has encountered, Win7 system computer blue screen, Windows system will automatically generate a blue screen error dmp files and blue screen pictures. Many users can not open DMP file, how to do? The following small series to explain the Win7 system can not open
Create an exp DMP file and use DD to destroy
The code is as follows
Copy Code
Sql> CREATE TABLE T_xifenfei as SELECT * from Dba_objects; Table created. Sql> Select COUNT (*) from T_xifenfei; COUNT (*)----------90915 [Oracle@localhost ~]$ exp CHF/XIFENFEI@PDB1 file=/tmp/t_xifenfei.dmp Tables=t_xifenfei Export:release 12.1.0.2.0 on Sun APR 27 21:39:26 2014 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights re
Oracle 10 Gb dmp how to import 9i Problem description: How to migrate database objects in oracle 10 Gb to 9i. the 10g and 9i servers are respectively built on two machines in the LAN and can access each other. problem Analysis: Some information has been found online, indicating that it is not feasible to import 10 Gb exported dmp files to 9i. only 9i can be imported to 10 Gb. if you want to import 10 Gb of
After a blue screen appears on the Windows 7 system computer, the system automatically restarts. After the computer is restarted, the system displays information about the blue screen. If you have no time to view the information, you can also go to the "Event Viewer" in Windows 7 (location: Control Panel-system and security-management tools-view event logs ), in the event viewer, you will also see the error system information. The general prompt is as follows:
"Dump data has been saved in: C:
After a blue screen appears on the Windows 7 system computer, the system automatically restarts. After the computer is restarted, the system displays information about the blue screen. If you have no time to view the information, you can also go to the "Event Viewer" in Windows 7 (location: Control Panel-system and security-management tools-view event logs ), in the event viewer, you will also see the error system information. The general prompt is as follows:"Dump data has been saved in the.
Oracle Data Import Export IMP/EXP is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and IMP commands the DMP file to be imported locally into a distant database server. With this feature, you can build two identical databases, one for testing and one for formal use.
Execution environment: can be executed in SQLPLUS.EXE or DOS
Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local to the distant database server. This function can be used to build two identical databases, one for testing and the other for formal use.Execution environment: it ca
Previously, the entire database was backed up, but because a table was accidentally deleted, You need to restore the accidentally deleted table from the backup. If you directly import the dmp file, because the data volume is large, you need
Previously, the entire database was backed up, but because a table was accidentally deleted, You need to restore the accidentally deleted table from the backup. If you directly import the
1. recently, I used Oracle many years ago to import oracle dmp files. The technology I used was nearly forgotten over time. Now I mark it here, so as not to feel helpless when you encounter the same problem again.
To import a dmp file, you need to know the user who created the dmp file. Therefore, you must first create a user and authorize it.
(1) User Creation
1. First, you must understand that the dmp file imported and exported from Oracle is executed using the cmd command, rather than SQL plus.
You can also use PLSQLDev to import and export data.
Note that the executable file export selects the exp.exe tool under the BIND installed on the client.
Ii. problems found in the export process:
The reason for online query is that there is a problem with the version of the database oracle server and the c
1. First, you must understand that the DMP file is imported and exported through the CMD command instead of the SQL plus command.
You can also use plsqldev to import and export data.
Note that the executable file export selects the exp.exe tool under the BIND installed on the client.
Ii. problems found in the export process:
The reason for online query is that there is a problem with the version of the database Oracle server and the clie
A lot of Windows users have a problem with the entire blue screen on the computer screen. Computer blue screen, also known as blue screen panic. is the screen image that the Microsoft Windows series operating system enforces when it is unable to recover from a system error to protect the computer's data files from being corrupted. So how does the Win7 system get the error report dmp file after the computer blue screen?
In the 9.2.0.8 RAC Environment, use EXP to dmp any error (per table, exported by user, remote EXP export using TNS method), including export after restarting the database, cannot be imported into other databases (this library, TNS method remote import, FTP transfer to remote import, 9i/ 10g/11g version) error similar to Setillegal instruction (coredump), paragraph errors, segmentation fault, etc., to the following out a few error information--Import 1
Label:First ask the table space name and size of the other database, then create the appropriate tablespace in your Oracle, and finally use the command to import and export the data.Add:1. To create a new database;Oracle data import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can beTo export data from the remote database server to a local DMP file, the IMP command can take the
Tags: DMP blog dmp file body echo color pos file name colExport database as DMP file, set file name according to current export time@ECHO Offecho back up data from SCOTT users ... SET Dbusername=Scottset Dbpassword=1234SET DBName=Orclset date_string=%date%SET time_string=%time%IF"%date_string:~3,1%"==" "(SET date_string=%date:~4,Ten%) ELSE (SET date_string=%date:
First ask the table space name and size of the other database, then create the appropriate tablespace in your Oracle, and finally use the command to import and export the data.Add:1. To create a new database;Oracle data import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can beTo export data from the remote database server to a local DMP file, the IMP command can take the DMP
Oracle DatabaseModerate timingDmp FileBackup can improve the security and stability of the database and facilitate recovery in the event of a fault. This article describes how to regularly back up the dmp file of an oracle database in SCO Unix. Let's take a look at it.
Prerequisites for backing up dmp files:
1. required information:
Oracle system password and account name and password for backing up data
Mysql and oracle batch processing run SQL file and oracle import dmp file bitsCN.com
Mysql and oracle batch processing run SQL files and oracle import dmp files
Mysql batch run SQL:
Net stop mysql
Net start mysql
Echo Wscript. Sleep (3000)> sleep. vbs
Start/w wscript.exe sleep. vbs
Del/Q sleep. vbs
Mysql-f-u mysql-ppassword anxiesoft
Net stop mysql
Net start mysql
Pause;
Oracle batch proc
ORA-39143ORA-39143: Dump File "C: \ Users \TT\ Desktop \ dir_dp \ 11111.dmp" may be the original export dump file
Import: Release 11.2.0.1.0-production on Wednesday August 7 10:29:58 2013Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rightsReserved.;;;Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionWith the partitioning, OLAP, data mining and real application testingOptionsORA-39001: Invalid parameter va
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.