URGENT - Export / Import [message #56273] |
Sun, 16 March 2003 12:45 |
Nita
Messages: 34 Registered: March 2002
|
Member |
|
|
Im running 8.1.7 Standard edition on a Win2000 server.
I performed an export on one table in my test database. The export completed successfully without warnings, and said 11043 rows exported.
I then performed an import to my production database - The message was Import Terminated successfully with warnings (However, no warning message).
When I performed a count(*) on the table in question in my production database the count returned 756 rows.
Any thoughts / suggestions would be greatly appreciated.
Nita
|
|
|
|
Re: URGENT - Export / Import [message #56281 is a reply to message #56273] |
Mon, 17 March 2003 02:56 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
Dear,
Check the followings-- PCT_INCREASE parameter,
Set the INITIAL and/or NEXT extent to a larger value (at least 99 times
what they are now to even have a chance of fitting in only one extent).
The default value is 5 data blocks (not much at all - around 20k
depending on your db_block_size) if not manually defined otherwise. So, if
you took the default value, you may have made your extents too small.
You may have also specified K when you intended to specify M
(kilobytes/megabytes) - so check your storage definitions.
This may help you...........
|
|
|
|