specifies the names
of the database and table space, which are separated by a period.
DATABASE database-name
specifies only the
database name. In this case, you 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 or table space.