OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » exp n imp (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp n imp [message #412446]

Thu, 09 July 2009 07:13

sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS

Member

Hi all,

I have done a full exp on oracle 10g on my production db and import
it on my test server. After importing on my test server i query one table.

select count(*) from t_mmhdr;

(PROD)Sun6 - 915 rows
(TEST)Sun4 - 840 rows

The count is not the same.

Can u help?

sailesh

Report message to a moderator

Re: exp n imp [message #412447 is a reply to message #412446]

Thu, 09 July 2009 07:18

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Can you post what you did?
Can you post the log files?
Can you post in the correct forum?
Can you follow the guidelines?

Regards
Michel

Report message to a moderator

Re: exp n imp [message #412449 is a reply to message #412447]

Thu, 09 July 2009 07:24

sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS

Member

hi,

exp system/password log=exp.log file=exp.dmp full=yes

1.imp system/password log=testcms.log file=testcms.dmp full=yes

This I did when i got the difference on count.

2.imp testcms/password log=testcms.log file=testcms.dmp fromuser=testcms touser=testcms

thanks,

Sailesh

Report message to a moderator

Re: exp n imp [message #412450 is a reply to message #412449]

Thu, 09 July 2009 07:32

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

Can you post what you did?
Can you post the log files?

Quote:

exp system/password log=exp.log file=exp.dmp full=yes

1.imp system/password log=testcms.log file=testcms.dmp full=yes

This I did when i got the difference on count.

2.imp testcms/password log=testcms.log file=testcms.dmp fromuser=testcms touser=testcms

Post log file details.

Thanks

Report message to a moderator