Home » RDBMS Server » Server Administration » error in view while moving schema from db1 to db2 (DB2 is oracle 11.2.0.3 and DB1 is 10.2.0.4 and Unix OS)
| error in view while moving schema from db1 to db2 [message #629853] |
Tue, 16 December 2014 13:03  |
 |
nareshrockdude
Messages: 12
Registered: December 2014
|
Junior Member |
|
|
Hello Experts,
I want to change one schema in DB1 to a new schema with a user in DB2. When I tried with data pump i have got an error that the DB versions are different so export is not possible. In this case I got the DDL of the schema in DB1 and then run the DDL schema in DB2 with a new schema. Everything went well except with few views that consists another schema from DB1. I got 19 errors and all of them are views related. Could you give me the solution how can i do this without errors.
FYI, I have included the error messages that I got
GRANT SELECT ON "HELP_OWNER"."EFINDS_INVENTORY_VW" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.EFINDS_INVENTORY_VW" has errors
GRANT SELECT ON "HELP_OWNER"."GGDEV_LOCS_AVAILABLE_FOR_OPS" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.GGDEV_LOCS_AVAILABLE_FOR_OPS" has errors
GRANT SELECT ON "HELP_OWNER"."GGDEV_PLACES_W_CURRENT_FLAGGED" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.GGDEV_PLACES_W_CURRENT_FLAGGED" has errors
GRANT SELECT ON "HELP_OWNER"."GGDEV_VW_ALL_LOCATIONS" TO "HELP"
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON "HELP_OWNER"."GGDEV_VW_COUNTY_EVACUATION" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.GGDEV_VW_COUNTY_EVACUATION" has errors
GRANT SELECT ON "HELP_OWNER"."GGDEV_VW_GENDER_CROSSTAB" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.GGDEV_VW_GENDER_CROSSTAB" has errors
GRANT SELECT ON "HELP_OWNER"."LOCATION" TO "HELP"
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON "HELP_OWNER"."LOCS_AVAILABLE_FOR_OPS" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.LOCS_AVAILABLE_FOR_OPS" has errors
GRANT SELECT ON "HELP_OWNER"."PAT_TRACK_RPT" TO "HELP"
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON "HELP_OWNER"."VW_AGE_EVAC_RECEIVED" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.VW_AGE_EVAC_RECEIVED" has errors
GRANT SELECT ON "HELP_OWNER"."VW_AGE_EVAC_RECEIVED_OLD" TO "HELP"
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON "HELP_OWNER"."VW_ALL_LOCATIONS" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.VW_ALL_LOCATIONS" has errors
GRANT SELECT ON "HELP_OWNER"."VW_COUNTY_EVACUATION" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.VW_COUNTY_EVACUATION" has errors
GRANT SELECT ON "HELP_OWNER"."VW_EVACUATIONS" TO "HELP"
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON "HELP_OWNER"."VW_GENDER_CROSSTAB" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.VW_GENDER_CROSSTAB" has errors
GRANT SELECT ON "HELP_OWNER"."VW_GENDER_EVAC_RECEIVED" TO "HELP"
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON "HELP_OWNER"."VW_LOCATIONS_TMSTMP" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.VW_LOCATIONS_TMSTMP" has errors
GRANT SELECT ON "HELP_OWNER"."VW_NOACTIONFACILITY" TO "HELP"
*
ERROR at line 1:
ORA-04063: view "HELP_OWNER.VW_NOACTIONFACILITY" has errors
GRANT SELECT ON "HELP_OWNER"."VW_REPATRIATED" TO "HELP"
*
ERROR at line 1:
ORA-00942: table or view does not exist
[Updated on: Tue, 16 December 2014 13:10] Report message to a moderator |
|
|
|
Current Time: Fri Apr 26 14:16:54 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
