but from two days i have loaded a table which was 70G -- after that i dropped it,
but i can't use create as select for table which is 9G now !!!
This forum is ONLY for sql developer questions/issues. Yours is a question for the General DB forum.
The license agreement for Oracle XE limits you to 11 GB of user space. Using, or attempting to use more than 11 GB is a violation of the terms of your license agreement.
i have this error,i created another table_spaces and i moved my tables on it, i think the problem is not related to the table_space size becuase i have free space, i am using EX
Yes - it is related to the amount of space you are trying to allocate/use. The exception is telling you that.
what is 11 GB i can't see any 11 GB in any table size ?
The 11 GB is the limit for the amount of space that can be ALLOCATED. Space can be allocated but unused. And CTAS operations use direct-path which may allocate its own space.
If you need more user space than 11 GB then you can NOT use Oracle XE.
If you need more help than the above mark the thread ANSWERED and repost it in the General DB forum