1 the original library is Linux + ora11g
I want to do the test in local win, win7x64 + ora11g

 
//on Linux 
Su - oracle 
Up sqlplus'/as sysdba '
The create user test11 identified by tpass; 
Grant dba to test11; 
Exp file=/me/data/bakdb DMP full=y 

Export end
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Local
In the imp import times wrong,
Ora is a new installation, can direct a library like MSSQL backup,

Imp file=/me/data/bakdb DMP full=y

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
An error content
IMP - 00003: ORACLE error 1119
ORA - 01119: create a database file '/oradata prodb/prodb. DBF' an error occurred when
IMP - 00015: because the object has been in existence, the following statement fails:
ORA - 27040: file creation error, unable to create the file
OSD - 04002: unable to open file
O/S - Error: 3 (OS) system could not find the specified path,
IMP - 00017:1119 due to ORACLE error, the following statement failure:

IMP - 00003: ORACLE error 959
ORA - 00959: a table space 'prodbc3' there is no
IMP - 00017:959 due to ORACLE error, the following statement failure:
ORA - 01917: user or a role 'EC_pro' there is no
IMP - 00017:1917 due to ORACLE error, the following statement failure:
IMP - 00003: ORACLE error 1435
ORA - 01435: the user does not exist
IMP - 00000: an unsuccessful termination of import

========================
Export when I set up a new user
Before the import I also set up a new user to import but you don't succeed,,,,

CodePudding user response:

Before and after using the same user? And suggest you table space cannot be created

CodePudding user response:

reference 1st floor ghx287524027 response:

export before and after using the same user? And suggest you unable to create table space

Is the same user
Established before export test11 users and gives the DBA permissions

Exp file=/me/data/bakdb DMP full=y
Will be prompted to enter the user name password test11 and password
.

CodePudding user response:

reference 1st floor ghx287524027 response:

export before and after using the same user? And suggest you unable to create table space

He did not suggest there is no direct creation,,,

CodePudding user response:

According to your way of thinking should be: building the user - export - delete users (cascade) - built the table space (if table space did not change, you don't need new) - build user (to specify the tablespace) - import

CodePudding user response:

reference 4 floor ghx287524027 response:

according to your way of thinking should be: building the user - export - delete users (cascade) - built the table space (if table space did not change, you don't need new) - build user (to specify the tablespace) - import

Is said to is because colleagues for different users also can't restore,,,

CodePudding user response:

reference 5 floor hackcsy reply:

Quote: refer to 4th floor ghx287524027 response:

According to your way of thinking should be: building the user - export - delete users (cascade) - built the table space (if table space did not change, you don't need new) - build user (to specify the tablespace) - import

Is said to is because colleagues for different users also can't restore,,,

It must ah, such as derived from the user A data file that you are unable to import to the user in the B

CodePudding user response:

Export the DMP file contains some basic configuration information, if you speak the configuration information to modify and new users, so also can guide go in, but this kind of change doesn't make sense, practice basic don't do that

CodePudding user response:

Imp import, bakdb. The DMP need to copy to your local client, cannot use the address of the server to perform

CodePudding user response:

refer to 7th floor ghx287524027 response:

export DMP file contains some basic configuration information, if you speak the configuration information to modify and new users, so also can guide go in, but this kind of change doesn't make sense, practice basic don't

. Elder brother that yo do,, you say me to do,,,

CodePudding user response:

refer to the eighth floor sxq129601 response:

imp import, bakdb. DMP need to copy to your local client, cannot use the address of the server to perform

).

Oh, then how to do

CodePudding user response:

references 9 f hackcsy response:

Quote: refer to 7th floor ghx287524027 response:

Export the DMP file contains some basic configuration information, if you speak the configuration information to modify and new users, so also can guide go in, but this kind of change doesn't make sense, practice basic don't

. Elder brother that yo do,, you say me to do,,,

DMP file can be use notepad or some tools to open, but you need to understand the beginning of the DMP file have all the information is what meaning, otherwise can easily

CodePudding user response:

11 references ghx287524027 response:

Quote: references 9 f hackcsy response:

Quote: refer to 7th floor ghx287524027 response:

Export the DMP file contains some basic configuration information, if you speak the configuration information to modify and new users, so also can guide go in, but this kind of change doesn't make sense, practice basic don't

. Elder brother that yo do,, you say me to do,,,

DMP file can be use notepad or some tools to open, but you need to understand the beginning of the DMP file have all the information is what meaning, otherwise easy to correction

20 G notepad is can't open,,,
That can be converted into mysql?

CodePudding user response:

Within 100 m can use notepad, 20 g if the
Mysql? What do you mean?

CodePudding user response:

reference 13 floor ghx287524027 reply:

100 m can use notepad, 20 g calculate
Mysql? What do you mean?

convert to other libraries,,,
Oracle good trouble,,,,
Want to import to oracle like server test well test,,,

CodePudding user response:

Data pump 20 g so big, why not