-
The exp/imp utility has a bug?
I tried the exp/imp utility to migrate the database from Windows XP SP2 to Redhat Linux FC4. I used the full mode. The export command I used is:
exp system/password full=y file=db.dmp grants=y rows=y consistent=y recordlength=65535
Then I transfer the file to the other OS and:
imp system/password full=y file=db.dmp grants=y rows=y recordlength=65535
Then I checked the data, I found the data is wrong, is this a bug of the utility or just my fault?
btw: The Oracle on both OS is 9.2.0.1.0
-
How did you get the file from Windoze to Linux? FTP?
-
-
define data is wrong, provide a clear example
-
For example in the original table there are two records :
154 2698 Japan
177 2337 USA
but in the table under Linux the records are
154 2698 USA
177 2337 Japan
There are some columns which are disordered!
-
That's really strange. Did you use direct path import?
-
there is no such thing called direct import!
also the order does not matter, when we say the data are different we mean the column values are not the same
-
I didn't use direct path. The file exported is about 4G, does it matter?
-
With Oracle, you never know which block the data goes to. Even when you insert data into tables, Oracle may place any row in any block. If you need to order data, then you need to use the ORDER BY clause. Otherwise your import looks fine.
-
It's not about order. It's some columns of one record are placed in other record.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|