Reputation
2,459
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
15 36
Newest
 Tenacious
Impact
~227k people reached

Oct
30
revised How to retrieve Oracle Key Performance Indicators in 5 minute intervals within a time range
added 3 characters in body
Oct
30
answered How to retrieve Oracle Key Performance Indicators in 5 minute intervals within a time range
Oct
27
comment Fill a GTT with external data each session
why not just truncate the GTT at the start of every run?
Oct
26
comment Error in trigger: table X is mutating, trigger/function may not see it
@Colin'tHart Well why not add a better answer then?
Oct
22
comment Proper way to upgrade Oracle database
@MindaugasRiauba from here it now says extended support until 2020, fees waived until 2017 but I think this means you must have an extended support contract to get patches blogs.oracle.com/UPGRADE/entry/no_extra_fee_for_extended
Oct
22
awarded  oracle
Oct
21
revised Proper way to upgrade Oracle database
added 468 characters in body
Oct
21
revised Reclaiming space from data files in Oracle
checked a comment I made and corrected it, incorporated in answer
Oct
21
revised Proper way to upgrade Oracle database
added 468 characters in body
Oct
21
answered Proper way to upgrade Oracle database
Oct
20
revised Reclaiming space from data files in Oracle
added 19 characters in body
Oct
20
comment Reclaiming space from data files in Oracle
My guess is you need data integrity more than you need disk space. Doesn't hurt to rebuild the indexes but there should be a reason to do so. Are they fragmented? If not, leave things alone.
Oct
20
answered Reclaiming space from data files in Oracle
Oct
20
comment Reclaiming space from data files in Oracle
What datafiles? Sys or SysAux tablespaces should be regarded with caution. Is the amount of data growing or static? Clob, non Clob?
Oct
9
revised Upgrade scenario: Oracle 8.0.5.0.0 to Oracle 12c?
added 19 characters in body
Oct
9
revised Upgrade scenario: Oracle 8.0.5.0.0 to Oracle 12c?
spelling
Oct
8
answered Upgrade scenario: Oracle 8.0.5.0.0 to Oracle 12c?
Oct
2
comment How to load Excel file into temp table in ORACLE
what tools do you have: SQL developer, Toad, PL/SQL developer?? they all have built in's to make it easier
Oct
1
comment Is it possible to downgrade oracle 11.1.0.6.0 to 10.2.0.4.0?
how about a fresh install of 10.2 (out of support for many years) and then import your data from 11g?
Sep
29
answered Getting PL/SQL: ORA-00942: table or view does not exist in plsql function but not from the command view