on 08-06-2008 8:42 PM
Hello,
is it possible to move tables with brtools from dictionary managed tablespace to another dictionary managed tablespace on Oracle 9.2 ?
Hello Axel,
this is a case where the BRSPACE error is not nice, because you have no easy chance to move this one table to a LMTS tablespace. In this case I would propose you to execute ALTER TABLE MOVE directly on Oracle side:
ALTER TABLE <table_name> MOVE TABLESPACE <target_tablespace>;
Afterwards all indexes of the table have to be rebuilt in order to validate them again:
ALTER INDEX <index_name> REBUILD ONLINE;
Kind regards
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
i tried to move the table with brtools to an dictionary managed tablespace and got the error:
"BR1099E Tablespace PSAPSTABD is not a locally managed tablespace"
the old tablespace layout is used an we dont't want to change ist anymore.
we make an DB check with brconnect every day and so we got an warning of an table in the wrong tablespace (Indextablespace PSAPBTABI).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
yes, why not?
you have the online reorganization available for tables without LONG fields.
If the table have LONG fields you have to perform an offline reorganization.
The destination tablespace can be Locally Managed or Dictionary Managed.
But, I do not recommended keep using Dictionary Managed tablespaces. If you are going to move a table, use the opportunity to do it to a LMTS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.