Import db link error

[sudheer_nm]

Hi Gurus,
I got the following error during import. Could any one suggest a solution.

IMP-00017: following statement failed with ORACLE error 2019:
"CREATE FORCE VIEW "ACC"."TAAC_EVENT" ("EVENT_TY"
"PE","SUB_EVENT_TYPE","RES_TYPE","RES_ID","DATE_STAMP","TIME_STAMP","DURATIO"
"N") AS "
"SELECT "EVENT_TYPE","SUB_EVENT_TYPE","RES_TYPE","RES_ID","DATE_STAMP","TIME"
"_STAMP","DURATION" FROM"
"ACC.TAAC_EVENT@tacc_link"

[quester]

What happens if you execute the statement seperately? Let me know..

[sudheer_nm]

Same error is coming

[Mr.Hanky]

Is that DB_LINK in place?

MH

[sudheer_nm]

Hi,
I haven't created any db_link. I am just exporting a dump file which was created using 7.3 export to 9i new database import.
Do i need to create all the db_link in 9i db before import??

[Mr.Hanky]

Originally posted by sudheer_nm
Hi,
I haven't created any db_link. I am just exporting a dump file which was created using 7.3 export to 9i new database import.
Do i need to create all the db_link in 9i db before import??

I think you do since it appears that the view it is trying to create is attempting to use that link. Try creating it and then run the SQL for that view, let us know what happens.

MH