OraFAQ Forum: Server Utilities » Triggers not imported

Home » RDBMS Server » Server Utilities » Triggers not imported

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Triggers not imported [message #147904]

Mon, 21 November 2005 10:53

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hi,

since the database is shutdown abnormally due to power failure, we have lost the RBS and hence the ora-01092 ORACLE instance terminated.Disconnection Forced error occured.As there is no other go, we have created new database manually and imported
the data from latest export dump.

After the import, it is seen that the Triggers are not imported.
we are having lot of triggers for dev.
why is it so..?
what might be the cause and how to fix..?

Plz help...!!

regards
bala

Report message to a moderator

Re: Triggers not imported [message #147941 is a reply to message #147904]

Mon, 21 November 2005 18:15

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Might be because they were not included in the export...

If they are in the export, then importing with ROWS=NO and TRIGGERS=YES

_____________
Ross Leishman

Report message to a moderator

Re: Triggers not imported [message #148046 is a reply to message #147941]

Tue, 22 November 2005 08:11

balavignesh
Messages: 180
Registered: March 2005

Senior Member

No. the export dump is having the full database and previously it was working good but now only it is happening...!!

i dont think there is an option like triggers=y

Report message to a moderator

Re: Triggers not imported [message #148056 is a reply to message #148046]

Tue, 22 November 2005 08:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post what you have done / logs/session snapshots.
Else we have NO idea what you are doing.
Try to recreate the triggers manually.

oracle@mutation#exp scott/tiger full=y file=scott.dmp

oracle@mutation#imp scott/tiger full=y show=y file=scott.dmp log=somefile.log

and somefile.log will have ddl of the trigger (if it was exported)

8061   "CREATE TRIGGER "SCOTT".mytrigg"
8062   "after insert on emp"
8063   "for each row"
8064   "begin"
8065   "null;"
8066   "end;"
8067   "ALTER TRIGGER "MYTRIGG"  ENABLE"

Report message to a moderator

Previous Topic:	Import problem - Need help
Next Topic:	sqlloader - want to include part of filename in insert

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 05:52:57 CST 2024