How to create a temp table as replica of original table

siquadri · #1 (**permalink**) 01-29-12, 20:29

Hi,

I have earlier taken snap shot of tables in temp tables in oracle using following comand

Code:

create table tablename1 as select * from table

Now i want to take snapshot of table in db2. Searched for few commands but could not find anything equivalent to above command in oracle.

Also is there a default temp schema in db2 where all developers will have access to create temp table.

Marcus_A · #2 (**permalink**) 01-29-12, 22:12

For the first question, check the CREATE TABLE xxxxx LIKE syntax in the manual.

For the second, look up Created Global Temporary Tables (CGTTs), a new feature in DB2 LUW 9.7. The schema name does not matter, as schema has a different meaning in DB2 than in Oracle.

Internet Services

Web Development

Digital Marketing

Consumer Tech