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

Hey Guys, We are attempting to export selective partitions of a table and would like to filter records for each partition. Would you please explain how we can achieve using one parameter file? Below is an example of the parameter file that we are using. For example, I have a tabl...

HI TOM, Tnx for this oppurtunity again, Can You explain how does the ORA-4068 occurs and how can I go about it? How does oracle manages the freelist (8i) on LMT's? And how can we track the freespace, used space, and fragmentation on LMT's? What's the difference between creating t...