Title: RE: Reverse Engineering Triggers
Steve,
I don't have a handy script, but if you're using 9i, you could
easily create something that just spools the output of
select dbms_metadata.get_ddl('TRIGGER',trigger_name) FROM USER_TRIGGERS;
then just run the spool f
Steve,
Here is a korn shell script I use. It also looks at
dba_trigger_cols. I was trying to do the same thing a
while back, but most of the scripts I found didn't
look at dba_trigger_cols. This view becomes important
if a trigger does something like 'before update of
on '. I will also use e
Anyone have a handy-dandy script to create a script which recreates
triggers? (By querying user/dba_triggers.)
Member of the Wheel Reinvention Prevention Society,
Steve Orr
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
Fat City N
hello gurus,
i would like know about the Reverse Engineering features of "ORACLE
designer 6"
i mean the level to which the Reverse Engineering feature goes
has any one tried them out?
i have reverse engineered the back end of a production database to
"physical database design
Roland,
Erwin has options for importing text files, so you could dump the
ddl for tables you are having problems with (Or all tables for that matter)
and import them as text into Erwin. At least you can play around with the
text file and hopefully figure out what the invalid character is,
Hallo,
I am doing a reverse engineer of the Oracle database, which means that I am loading
the database into the program Erwin. When it i simported into erwin I willbe able to
seeall the relations, tables, views etc of the database. But when i am doing the
reverse engineer I get many error me