rsim / oracle-enhanced

Oracle enhaced adapter for ActiveRecord
MIT License
549 stars 310 forks source link

Oralce SYSTEM tablespace growing without limit #436

Closed BrandonMathis closed 10 years ago

BrandonMathis commented 10 years ago

My oracle SYSTEM tablespace is growing without limit and I think that this happens when I run db:drop and db:schema:load. Is there any way to clear this out?

oracle developer days running 2014-04-14 11-40-36 2014-04-14 11-40-45

This is blocking me from using oracle because I get this error.

ActiveRecord::StatementInvalid: NativeException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_COBJ# by 128 in tablespace SYSTEM
: CREATE TABLE "SCHEMA_MIGRATIONS" ("VERSION" VARCHAR2(255) NOT NULL)

This is possibly an issue with the rake tasks? I don't think we should be using SYSTEM tablespace :-/

hermiti commented 10 years ago

I would purge your recycle bin.

purge recyclebin;
purge user_recyclebin;
purge dba_recyclebin;
BrandonMathis commented 10 years ago

Thanks. My garbage bin is really full. I'll give it a shot when I'm back at the office and let you know. All the Oracle forums were leading me to believe it was an issue with the way the schema was loaded in. On Apr 14, 2014 12:18 PM, "Tim Rock" notifications@github.com wrote:

I would purge your recycle bin.

purge recyclebin; purge user_recyclebin; purge dba_recyclebin;

— Reply to this email directly or view it on GitHubhttps://github.com/rsim/oracle-enhanced/issues/436#issuecomment-40386020 .

BrandonMathis commented 10 years ago

That fixed it :) Thanks for the help @hermiti!