network profile
| bio | website | dba010.wordpress.com |
|---|---|---|
| location | Tbilisi, Georgia | |
| age | 22 | |
| visits | member for | 1 year, 10 months |
| seen | Apr 5 at 12:57 | |
| stats | profile views | 78 |
I am OCA and I work as a DBA at JSC Bank of Georgia.
|
Nov 9 |
awarded | Tumbleweed |
|
Nov 6 |
comment |
ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal Note2: I found that DBMS_UTILITY.INVALIDATE also invalidates any objects that (directly or indirectly) depend on the object being invalidated :((((((( I don't want it :S |
|
Nov 6 |
comment |
ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal Note: I have granted the following privileges to SYS schema: CREATE ANY DIMENSION, CREATE ANY EVALUATION CONTEXT CREATE ANY INDEX CREATE ANY INDEXTYPE CREATE ANY LIBRARY CREATE ANY MATERIALIZED VIEW CREATE ANY OPERATOR CREATE ANY PROCEDURE CREATE ANY RULE CREATE ANY RULE SET CREATE ANY SYNONYM CREATE ANY TRIGGER CREATE ANY TYPE CREATE ANY VIEW but did not help... |
|
Nov 6 |
asked | ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal |
|
Nov 2 |
asked | RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept? |
|
Nov 1 |
accepted | How to disable instance recovery in ORACLE? |
|
Nov 1 |
comment |
Eliminate database fragmentation (export, drop and re-import tables) @JackDouglas please let's discuss: First of all I do export of all objects(GRANTS,INDEXES,TRIGGERS,CONSTRAINTS) then drop that tablespace with its datafiles, create new tablespace, do import..What can be lost? |
|
Nov 1 |
comment |
ORA-01555: snapshot too old: rollback segment number with name “” too small @JackDouglas do u mean the version? 10.2.0. I did the following workaround: updated these values by empty_clob() and after then I was able to move that table to another tablespace(it was definitely corrupted). But this is just a workaround not a solution |
|
Oct 28 |
comment |
ORA-01555: snapshot too old: rollback segment number with name “” too small @JackDouglas It is very strange, when I use dbms_repair it doesn't show any corruption .. if I select table containing lob segment there is values in lob column <NCLOB> ... and one <Value Error> what is it? |
|
Oct 28 |
comment |
ORA-01555: snapshot too old: rollback segment number with name “” too small As I found, I have corrupted lob segment. I know its rowid. Do I have a chance to recover it? |
|
Oct 28 |
asked | ORA-01555: snapshot too old: rollback segment number with name “” too small |
|
Oct 27 |
comment |
Eliminate database fragmentation (export, drop and re-import tables) @OweHesse and what about indexes and lob segments are they shrunk also or should I do it manually? |
|
Oct 27 |
comment |
Eliminate database fragmentation (export, drop and re-import tables) @OweHesse Thank you for your great answer. One question. Srinking table requires enabling row movement and after performing shrinking, should I disable it or will it be disables automatically(I mean row movement).If it is enables will it cause any problem? |
|
Oct 27 |
accepted | Undo DDL statement on View in Oracle |
|
Oct 27 |
accepted | Oracle Backup and Recovery Issue |
|
Oct 27 |
accepted | ADMINISTER DATABASE TRIGGER privilege |
|
Oct 27 |
comment |
Eliminate database fragmentation (export, drop and re-import tables) @JackDouglas It is a test server but very important one, I must not loose any data. We need space. I am also planning to migrate that database to another server but not now. Sysadmins are not adding space to this server. So my last chance is to free up that space for other services. There is also installed JBOSS. Why do you think that export/import a last resort? Is there any change to loose something? |
|
Oct 27 |
comment |
How to disable instance recovery in ORACLE? The reason is that 4 blocks in one datafile(that is not system datafile) is corrupted, and Oracle is trying to recover them but crashes after server tries(as I found it is caused by a bug in 10.2.0.4). I want my DB to start normally without trying recovery and I will recover that blocks myself from backup, or will move that object to another tablespace. |
|
Oct 27 |
comment |
Eliminate database fragmentation (export, drop and re-import tables) @JackDouglas thank you. Answer is because I don't have space on server I have just 153MB, not enough for creating another tablespace and migrating objects. I mapped new network drive and want to export there. My tablespace is locally-managed with AUTOALLOCATE. Version is 10g(10.2.0.3.0) |
|
Oct 27 |
asked | Eliminate database fragmentation (export, drop and re-import tables) |
