I've created a new database in Informix IDS9.30 without using the "IN <dbspace>" clause in the "CREATE DATABASE" statement. Hence, it caused all tables for this database being created into the rootdbs (the default dbspace) automatically. As the result, I have been forced to add more chunks onto rootdbs when my database growth.
Is there any methods to reset/modify the DATABASE's default dbspace (rootdbs) to other dbspace? FYI, due to my application limitation, I can't set the dbspace in each "CREATE TABLE" statement and have to reliant on the database's default dbspace. Any idea?
The only supported action is (I think) to dbexport (better to use the -ss option) the whole database and import it again with dbimport. dbimport has an option to specify the database default dbspace. Just do dbimport -- and it will show you the syntax.