Information on System Tables
Hello Friends,
I want the information on system tables of oracle and other information on oracle tables.
Actually I want to know where the oracle procedures and other PL/SQL blocks, triggers are stored. I had created a trigger in oracle which is written in a file with new.sql. The trigger was created succesfully. After that I deleted the file new.sql. now I want the code that i had wirtten in that trigger.how I can get that information. i.e., In which user/system table the trigger and procedures information will be stored.
I waiting for your reply.
bye.
I want the information on system tables of oracle and other information on oracle tables.
Actually I want to know where the oracle procedures and other PL/SQL blocks, triggers are stored. I had created a trigger in oracle which is written in a file with new.sql. The trigger was created succesfully. After that I deleted the file new.sql. now I want the code that i had wirtten in that trigger.how I can get that information. i.e., In which user/system table the trigger and procedures information will be stored.
I waiting for your reply.
bye.
triggersand procedures are stored in database you may see its definitons, status etc from user_triggers, all_triggers, dba_triggers, user_procedures...
Deleting your sql file doesnot have any affect after creation. if you want to delete tem issue the command:
alter table <tablename> drop trigger <triggername>;
drop procedure <procedurename>;
Deleting your sql file doesnot have any affect after creation. if you want to delete tem issue the command:
alter table <tablename> drop trigger <triggername>;
drop procedure <procedurename>;
ASKER
I donot want to delete the trigger. After deletion of my sql file. The code I written for that trigger will be no more. after I want to get the code from the trigger created in oracle. Where the code will be stored. Is the code of any procedure will store only in files or in any other format in oracle.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please reply soon a small request how to see the users table space ie, where his tables are storing.
user_triggers,all_triggers
For procedures:
user_procedures,all_proced