read-only partition

[Sharon Zzz]

Hi,

 

I am trying to put the historical data into read-only dbspace by using partition:  Here is my implementation: (The table was originally created in ARCHIVE_1 dbspace)

 

alter table PST_OrderUpd partition by range (tradedateid)
(
    PST2013 values <= (20131231) in ARCHIVE_1,
    PST2014 values <=(20141231) in DATA_MAIN1,
    PST2015 values <=(20151231) in DATA_MAIN1
)

 

After this I changed the ARCHIVE_1 to read-only mode.  However when I tried to insert current data into the table i.g. insert tradedateid=20141105, it failed by throw error message:

 

**************************************************************************************************************

 

SQL Anywhere Error -1009058: There are no dbspaces open in readwrite mode for this RW operation,
-- (st_database.cxx 7238)
 Msg: 21, Level: 14, State: 0

 

*****************************************************************************************************

 

Thanks.

 

Sharon