Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-0092 TABLE OR VIEW DOES NOT EXIST

433935Jun 20 2011 — edited Jun 21 2011

Dear Friends

I have export my table by this script
SET_APPLICATION_PROPERTY(CURSOR_STYLE,'BUSY');

HOST('D:\ORA_UTL\BIN\EXP PROJ/JEDDAH123 FILE=D:\ORACLE_BACKUP\JEDFOAM'||TO_CHAR(SYSDATE,'DD-MM-YYYY')||'.DMP');

SET_APPLICATION_PROPERTY(CURSOR_STYLE,'default');
SYNCHRONIZE;
-- SHOW_MESSAGE('Backup Finish');
EXIT_FORM(NO_COMMIT,NO_ROLLBACK);

And I have use this import script for importing the above file

JEDFOAM19-06-2011.DMP FULL= YES
= IMP EXP PROJ/JEDDAH123 FIL

So I am getting this message
ORA-0092 TABLE OR VIEW DOES NOT EXIST

So I have to do this for each table
CREATE PUBLIC SYNONYM messages FOR PROD.messages

Waiting for your valuable answer

Best regards

Jamil Alshaibani

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2011

Added on Jun 20 2011

#forms, #moved-from-devops

3 comments

1,839 views