A temporary table is associated with a session, not with a database. When you create a temporary table, you cannot create another temporary table with the same name (even for another database) until you drop the first temporary table or end the session. The name must be different from the name of any other table, view, sequence object, or synonym in the current database, but it need not be different from the temporary table names that are declared by other users.
In an ANSI-compliant database, the combination owner.table must be unique in the database.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]