Home » RDBMS Server » Server Utilities » exp n imp (oracle 10g)
exp n imp [message #412446] Thu, 09 July 2009 07:13 Go to next message
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
Re: exp n imp [message #412447 is a reply to message #412446] Thu, 09 July 2009 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: exp n imp [message #412449 is a reply to message #412447] Thu, 09 July 2009 07:24 Go to previous messageGo to next message
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
Re: exp n imp [message #412450 is a reply to message #412449] Thu, 09 July 2009 07:32 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: exp n imp [message #412451 is a reply to message #412450] Thu, 09 July 2009 07:37 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Alos; Your exported dump file name file=exp.dmp & Your trying to import differnt dump file file=testcms.dmp

Thanks

[Updated on: Thu, 09 July 2009 07:37]

Report message to a moderator

Re: exp n imp [message #412545 is a reply to message #412451] Thu, 09 July 2009 23:33 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

I made a mistake in typing it is indeed testcms.dmp After importing the count on both tables is not the same.

Thnaks,

Sailesh

Re: exp n imp [message #412546 is a reply to message #412446] Thu, 09 July 2009 23:34 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I made a mistake in typing it is indeed testcms.dmp
Please enroll in a class for remedial CUT & PASTE training.
Re: exp n imp [message #412549 is a reply to message #412546] Thu, 09 July 2009 23:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BlackSwan wrote on Fri, 10 July 2009 06:34
>I made a mistake in typing it is indeed testcms.dmp
Please enroll in a class for remedial CUT & PASTE training.


Laughing

Re: exp n imp [message #412557 is a reply to message #412549] Fri, 10 July 2009 00:14 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member



Smile

Quote:

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


Did you read Mr Mic question? Please response that question.
Previous Topic: SQLLDR - look up on table to find column value
Next Topic: size of database which i m going to export
Goto Forum:
  


Current Time: Fri Dec 09 04:16:37 CST 2016

Total time taken to generate the page: 0.10313 seconds