Hi,

I'm processing the archiving of our live company (100) to an archive company (200). I add the archive comapny (200) into ORA_STORAGE and create two tablespaces (data and index). During the archive process, I noticed that the tablespaces of archive company are note populated but those of company 000.
What is missing?
I appreciate your help.

Hi Macahu,

Did you add the entries for company 200 before the general entries in ora_storage?

Like this:

*:200:T:group:0214:5:PCTFREE 5 TABLESPACE ARCHDAT INITRANS 3
*:200:I:group:0214:5:PCTFREE 5 TABLESPACE ARCHIDX INITRANS 3
*:*:T:group:0214:5:PCTFREE 5 TABLESPACE BAANDAT INITRANS 3
*:*:I:group:0214:5:PCTFREE 5 TABLESPACE BAANIDX INITRANS 3

And I assume you created the tables for company 200 after changing ora_storage?

Cheers,

Nick

Thanks Nick,

No I put the entries of archive company in the middle of the file, like:

*:000:T:group:0214:5:PCTFREE 5 TABLESPACE BAAN000 INITRANS 3
*:000:I:group:0214:5:PCTFREE 5 TABLESPACE BAANINDX000 INITRANS 3
*:200:T:group:0214:5:PCTFREE 5 TABLESPACE ARCHDAT INITRANS 3
*:200:I:group:0214:5:PCTFREE 5 TABLESPACE ARCHIDX INITRANS 3
*:*:T:group:0214:5:PCTFREE 5 TABLESPACE BAANDAT INITRANS 3
*:*:I:group:0214:5:PCTFREE 5 TABLESPACE BAANIDX INITRANS 3

Should the company 200 in the first lines?

for the second question I'm not sure on the time of changing ora_storage.

Regards

The entries are okay as long as they come before the "*|*" entries.

The ora_storage file is only used when creating the tables. So if you already had created the tables of your archive company and changed your ora_storage afterwards this will have no effect until the tables are re-created (f.e. when you perform a "Reorganize tables" with "Data and Indices" checked).

Hope this helps...

Nick

Ok Nick,

I'll try and be back to you.

Best regards

Hi Nick,

Your were right, the Ora_storage has been changed after tables creation in company 200.
I create a sequential dump of table for company 200 afterwards I delete the tables and create them and finally I create table from sequential dump. And it works fine.

Thanks a lot for your help