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

2d
answered multi-tenant data related to multiple customer?
2d
revised Is there a way to reference a column dynamically within a trigger?
added 8 characters in body
2d
answered Is there a way to reference a column dynamically within a trigger?
Apr
21
revised looking for a lighter alternative to cognos express
edited body
Apr
21
revised looking for a lighter alternative to cognos express
updated logi versions and formatting
Apr
21
awarded  Revival
Mar
29
comment Is deleting secondary files a bad idea?
how do you know they are superfluous? If they are empty will data be loaded into them again in the future?
Mar
20
comment How to create a function(table_name) that return a collection in Oracle?
@JustinCave Yes, that would be cleaner and less work
Feb
24
comment Optimize large table design
I see many databases that "just grew" that don't have enough memory or free disk space. I don't suppose a hardware upgrade is possible...
Feb
23
answered Can you view the Oracle listener status from OEM?
Feb
22
answered Selecting from random amount of tables with identical structure
Feb
22
comment Selecting from random amount of tables with identical structure
please, just show us some of the table definitions, your example leaves me unclear as to what you are describing
Feb
1
answered Serialize :new in trigger
Jan
21
comment Performance tuning of a SQL query
Please add some explain plans so we can see what plan the database is using. Telling us the oracle version is always helpful too.
Dec
18
comment I need to update a Oracle procedure via a .sql script
If you run that script in sql developer it will replace the existing procedure and will not change any data. Oh, and why do you put this on the client box, surely an onlogon trigger run from the database would avoid this?
Dec
11
comment Oracle Enterprise Manager 11g - restricting tablespace access
When he logs into OEM it is likely any commands issued run with the privileges of the OEM user. You should create a read only OEM user as a test.
Dec
8
comment Migrate/Export DB from Oracle 11g Enterprise to Oracle 11g Express
how big is the database in file size? Does it use partitioning?
Nov
27
comment Oracle Materialized View Overloads Database
Depending on the importance of availability of the tables better hardware is probably cheaper and more effective. I see many production Oracle databases getting by on just enough memory when there is more that could be allocated.
Nov
25
answered Sync data between 2 databases Oracle 10g
Nov
24
revised Oracle - Service Account vs Database Account?
added 32 characters in body