Hi folks, I wrote a procedure that downloads spatial information for power lines via WFS from a web site and merges this into an existing table in my ADB. I wrote it in a way that it should use the parallel mode (pipelined table function, no triggers, jala jala...). This works gr...

creating unique key and primary key on same column is possible? already unique key and not null constrains there on same column but still i want to create primary key without dropping unique key.

I am implementing a 4-Schema SmartDB architecture for an Oracle APEX project to strictly enforce the principle of least privilege. My schemas are: DATA_LAYER (Tables), LOGIC_LAYER (Private Logic), API_LAYER (Public Interface), and APEX_UI_LAYER (Parsing Schema). I am currently de...

How can you make an oracle table, index or partition 'lose' its storage definition and revert to tablespace defaults... I have a 'legacy' table in production that was built with storage parameters inherited from the 'consolidate storage' option on the old export utility (exp). It...

Hello , during the connection 'storm' (for example after restarting app servers , because of DB maintenance tasks ) i observe high amount of these commands: update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1 roughly , 30 % of