cancel
Showing results for 
Search instead for 
Did you mean: 

move Table on Ora 9.2 from tablespace to another (dictionary managed)

axel_huber
Discoverer
0 Kudos

Hello,

is it possible to move tables with brtools from dictionary managed tablespace to another dictionary managed tablespace on Oracle 9.2 ?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

axel_huber
Discoverer
0 Kudos

Hello,

is solved the problem:

1. exoprt the table with brtools (exp)

2. drop table

3. create table new (with DLL statement of the old table and change of the tablespace)

4. import the table with brtools (imp)

axel_huber
Discoverer
0 Kudos

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).

0 Kudos

Hi,

Thanks, I did not know about that limitation.

You could do the reorganization offline.

or without using the BR* tools.

Can you post the warning message here?

axel_huber
Discoverer
0 Kudos

Hello,

i tried the reorg with offline SAP Instance.

what do you mean with "without using the BR* tools" ?

The error of brtools was:

"BR1099E Tablespace PSAPSTABD is not a locally managed tablespace"

0 Kudos

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