I use the exp command to export of oracle database table, but less export DMP file section default values and not null constraint (not all, a table three fields have a not null constraint, export to two, there is a guide not to come out) seeks advice!!
1, execute the command: exp userid=$USER1 tables=uploadlog file=Image. The DMP grants triggers rows=n=n=n indexes constraints==n n
2, compared to the original database structure and export the DMP file structure:


Obviously, the second picture of the not null, another table field default value is same, this situation after the export is no!

CodePudding user response:

The great god help me quickly see ah

CodePudding user response:

You set the constraints=n, constraints not guide, the not null non-null constraint

CodePudding user response:

refer to the second floor sxq129601 response:

you set constraints=n, constraint does not guide, the not null non-null constraint

but you look at the picture 1, there are three not null, but only the second not null not to export, derived the first and the third is coming, I add the constraints=n is mainly in order to get rid of the primary key constraint!

CodePudding user response:

refer to the second floor sxq129601 response:

you set constraints=n, constraint does not guide, the not null non-null constraint

I removed it, he just added the pk, did not add that the not null

CodePudding user response:

reference 4 floor number2012 response:

Quote: refer to the second floor sxq129601 response:

You set constraints=n, constraint does not guide, the not null non-null constraint

I removed it, he just added the pk, did not add the middle of the not null

That is strange, you test the changing pid to pid2 try? Pid is the key word conflict? But it is not,

CodePudding user response:

reference 5 floor sxq129601 reply:

Quote: refer to 4th floor number2012 response:

Quote: refer to the second floor sxq129601 response:

You set constraints=n, constraint does not guide, the not null non-null constraint

I removed it, he just added the pk, did not add the middle of the not null

That is strange, you test the changing pid to pid2 try? Pid is the key word conflict? But it is not ah,

ah, clothing, tried a lot of methods are not line!

CodePudding user response:

Pid column, with foreign key constraints?

You to build the first table statements are posted, including primary keys, foreign keys, etc.,

Also said you database version, including small version!

CodePudding user response:

1, exp contraints option, do export restrictions, primary keys, foreign keys, not null and check all calculate,
2. In addition, with the same contrast the DDL statements on both sides of the tool or way,

Wish wmxcn2000 great god, and other friends, New Year's day festival happiness!