on 2012 Apr 11 11:14 AM
What I am going to do is to create a dbspace that contains a table(s) that is existing in the main database file. Anyone know how to do it?
AFAIK, there is no SQL Statement to "move" a table, so you will have to
Splitting existing databases
If you want to split existing database objects among multiple dbspaces, you must unload your database and modify the generated command file (named reload.sql by default) for rebuilding the database. In the reload.sql file, add IN clauses to the CREATE TABLE statements to specify the dbspace for each table you do not want to place in the main file.
If you would like to move the table in order to "free" the space of the system dbspace, then I guess method 2 is necessary, as a dbspace won't shrink without a rebuild.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
10 | |
10 | |
10 | |
10 | |
8 | |
8 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.