| snapshot not get exported [message #73512] |
Thu, 13 May 2004 05:21  |
vilas
Messages: 7
Registered: May 2004
|
Junior Member |
|
|
Hi All,
I m using Oracle8i(8.1.7). im using EXP utitlity to export data. everything is working ok except my materialized view not get exported.
The table which is created by snapshot is get exported but not definition.
so when i try used that view it. like this DBMS_MVIEW.REFRESH('MVIEW_SUMMARY); it gives me the error
can anybody explain what are the parameters for exporting complete snapshot.
TIA
vilas
|
|
|
|
| Re: snapshot not get exported [message #73518 is a reply to message #73512] |
Thu, 13 May 2004 23:49  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
First of check the View User_tables, your MV must be listed there as a Table.
This is because your mviews must have been based on ROWIDs.
ROWIDs change do not survive a reorganization because its based on the block information (file, row#, etc.)
So when you reorganize a table, which is what happens during export/import, ROWIDs change.
But instead of NOT importing the mview, it has imported it as a Table.
If you had mviews based on PRIMARY KEY, you will not get the erorr.
So now you should drop and recreate your mviews. Let the snaphsots logs remain as it is.
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
