Temporary tables
Hi,
Do temporary tables created in the database (via the CREATE GLOBAL TEMPORARY TABLE) with a schema prefix and without one make a difference in terms of access ? (My understanding is that in terms of storage, they can, as they are created in the default temporary tablespace of the user creating it, so if user A creates them, they rows get stored upon insert in the default temporary tablespace for user A which may be different to that for user .
Regards,
Rakesh
Do temporary tables created in the database (via the CREATE GLOBAL TEMPORARY TABLE) with a schema prefix and without one make a difference in terms of access ? (My understanding is that in terms of storage, they can, as they are created in the default temporary tablespace of the user creating it, so if user A creates them, they rows get stored upon insert in the default temporary tablespace for user A which may be different to that for user .
Regards,
Rakesh
0