Table, Triggers and Process ids
tx103108Feb 15 2010 — edited Feb 15 2010When a table is dropped, are any associated triggers dropped also or just invalidated? I have a tool that creates a table, then drops the table, then on the next run recreates the same table again. I would like to not have to recreate the trigger each time as well (the trigger is created in house and not by the tool).
Is there a way to create a table that has a unique name, such as mytable$$ where $$ is the process id (in UNIX)? Each time I run this tool it creates the same table structure but a new table (instead of just truncating the table -- not a good tool I admit). I want to know if PL/SQL or SQL can do this by attaching, for example, a process id number.
OS: Solaris
DB: Oracle 10g