Skip to Main Content

SQL & PL/SQL

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!

Table, Triggers and Process ids

tx103108Feb 15 2010 — edited Feb 15 2010
When 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2010
Added on Feb 15 2010
4 comments
458 views