Home » RDBMS Server » Server Utilities » Schema Refresh (Oracle 10.2.0.3 Linux AS4)
Schema Refresh [message #393201] Fri, 20 March 2009 13:26 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

We have done a schema export on production and import into Developement.I'm confused where in one table in the production there are 25297295 rows but where as when we imported into the Development server that table got only 25290780 rows .

What might be the reason behind this ?

The total count of the objects of that schema in the production as well as Development is exact.

Clarification on this will be great help to me

Regards,
Raj

Re: Schema Refresh [message #393203 is a reply to message #393201] Fri, 20 March 2009 13:30 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>What might be the reason behind this ?
Not all the rows got loaded.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: Schema Refresh [message #393207 is a reply to message #393201] Fri, 20 March 2009 13:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to provide us something to work with.
We cannot guess everything.
Re: Schema Refresh [message #393242 is a reply to message #393207] Fri, 20 March 2009 15:58 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>>Clarification on this will be great help to me

Yes. Post your export and import log file

Babu
Previous Topic: Error in Loading Data with SQLLDR in Oracle 10G
Next Topic: missing trigger/procedures after import
Goto Forum:
  


Current Time: Sun Dec 04 21:06:44 CST 2016

Total time taken to generate the page: 0.08992 seconds