Hello
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
I have the following commands
alter tablespace users offline ;
CREATE TABLE dummy_t
(
ID NUMBER NOT NULL
);
Table DUMMY_T created.
CREATE TABLE dummy_t_xml
(
ID NUMBER NOT NULL
, XML_VALUE SYS.XMLTYPE
)
XMLTYPE XML_VALUE STORE AS BINARY XML;
SQL Error: ORA-01542: tablespace 'USERS' is offline, cannot allocate space in it
01542. 00000 - "tablespace '%s' is offline, cannot allocate space in it"
*Cause: Tried to allocate space in an offline tablespace
*Action: Bring the tablespace online or create the object in other
tablespace
Is there some way to create this table without the XMLTYPE allocating storage on creation (which I assume is the cause for error)?
Thanks for any help