General ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device while starting the DatabaseORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device SQL*Plus: Release…VeeraDecember 22, 2014
General Flashback the Database Using SCN Bringing Back The Database to Previous State after Importing a schema Using Flashback Technology…VeeraOctober 26, 2014
General PREVENT USERS (SCHEMAS) FROM GETTING DROPPEDThe below Trigger is used to prevent users and schemas from Getting Dropped Mistakenly, Create…VeeraOctober 26, 2014
General Recreating the Oracle Inventory files in Oracle 10g and Oracle 11gNormally, an oraInventory directory will be created in the system when we run the Oracle…VeeraOctober 26, 2014
General Table De-Fragmentation to Reclaim the Space and Different Methods of De-FragmentationENVIRONMENT ============= SERVER NAME SERVER1 DATABASE NAME TESTDB (more…)VeeraOctober 26, 2014
General PREVENT USERS (SCHEMAS) FROM GETTING DROPPEDThe below is the Trigger which is used to prevent the users or schemas from…VeeraOctober 26, 2014
General Purging statistics from the SYSAUX tablespaceIn Oracle Database, Whenever statistics in the dictionary are modified, old versions of statistics are…VeeraOctober 26, 2014
Recent Comments