How does the Oracle Server handle temporary tables?
By default, the Migration Workbench uses the temporary tables feature of Oracle9i. When the parser encounters SQL statements such as CREATE #TABLE in a stored procedure, the parser explicitly creates a temporary table. When the parser encounters SQL statements such as INSERT INTO #TABLE in a trigger or stored procedure, it implicitly creates a temporary table. An implicit creation is required when a CREATE TABLE statement cannot be found. These creation (DDL) statements are associated with stored procedures and triggers and are executed by the Migration Wizard before the stored procedures or triggers are created. Clashes can arise when the parser creates multiple copies of the same DDL statement. The clashes are written to the Log window and you can ignore them.
