specifies the names
of the database and table space, which are separated by a period.
Enclose the entire specification in single quotation marks.
DATABASE database-name
specifies only the
database name. Specify the word DATABASE, a space, and the database
name. Enclose the entire specification in single quotation marks.
Details
The IN= option is relevant
only when you are creating a new table. If you omit this option,
the default is to create the table in the default database, implicitly
creating a simple table space.