NO SPACE
Syntax
SET NO SPACE;
Description
Prevents tablespaces from being created. This is the default setting. You can use this statement to reset the default after executing a SET SPACE statement.
Parameters
IMPORT and REPLACE_ALL.