Reputation
2,609
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
15 37
Newest
 Revival
Impact
~248k people reached

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
Sep
25
comment Oracle jobs not running
check the run log, what is the next scheduled run time and, most importantly, what is the time zone you are in vs the time zone the scheduler is using?
Sep
17
answered is there a way to connect to mysql using oracle sqlplus instant client
Sep
17
comment Database monitoring dashboard
12c cloud control can monitor Oracle database and send emails if they are down. That is the least of what it can do.
Sep
15
revised Oracle: How do I add users to the HTTP ACL in Oracle 11?
edited tags
Sep
15
comment Oracle: How do I add users to the HTTP ACL in Oracle 11?
You should note that this is relevant for oracle 11 and changed for Oracle 12
Sep
10
comment Getting an error “ORA-00093: pga_aggregate_target must be between 10M and 4096G-1” on Oracle DB startup
Your web link does not say to edit the spfile which normally results in further errors. It indicates to create a pfile from spfile and then edit that.
Sep
8
comment Oracle: How to create a “reverse” index primary key?
For my own information: why would I want to create a reversed index?
Aug
28
comment Query on Sqlplus utility
what happens when you open a command prompt and type sqlplus?
Aug
26
awarded  Notable Question
Aug
11
comment What will happen if I drop SYSAUX tablespace from Oracle 11G
Just because you can doesn't mean you should....