CREATE DB ... and TABLESPACE-Names

bab · #1 (**permalink**) 02-25-04, 12:46

hi all,

is there any way to set the names of Tablesspaces (USER, CATALOG, TEMPORARY) when creating with "CREATE DATABASE ... " command?

hmmmmmm ...

or ist the "RENAME TABLESPACE xxx TO yyy" the only way?

thank a lot

sathyaram_s · #2 (**permalink**) 02-25-04, 15:58

AFAIK, RENAME is the only option ...

Remember, you can be able to rename SYSCATSPACE

HTH

sathyaram

Quote:

Originally posted by bab
hi all,

is there any way to set the names of Tablesspaces (USER, CATALOG, TEMPORARY) when creating with "CREATE DATABASE ... " command?

hmmmmmm ...

or ist the "RENAME TABLESPACE xxx TO yyy" the only way?

thank a lot

Internet Services

Web Development

Digital Marketing

Consumer Tech