table in table space

Klp · #1 (**permalink**) 11-10-05, 06:27

Is it possible to insert a already existing table into a tablespace with an SQL ?

J Petruk · #2 (**permalink**) 11-10-05, 08:13

Quote:

Originally Posted by Klp

Is it possible to insert a already existing table into a tablespace with an SQL ?

Do you mean move a table from one tablespace to another?

Unfortunately, no. You need to export-drop-create-import/load.

Klp · #3 (**permalink**) 11-10-05, 11:02

The table already exists but not in a tablespace ( or the default one )

J Petruk · #4 (**permalink**) 11-10-05, 11:23

All tables exist in a tablespace, it's likely in USERSPACE1, the default SMS tablespace.

Same answer applies, unfortunately, it can't be moved without a drop & re-create.

Internet Services

Web Development

Digital Marketing

Consumer Tech