Site Map


  • 11g Deferred Segment: ORA-01950: no privileges on tablespace
  • 5 Different Methods to Partition a non partitioned Oracle table, PARTITION EXCHANGE, SPLIT, Redefinition
  • Add Datafile, Create tablespace to Oracle database runing on ASM or with Oracle-managed files? Fix ORA-01276
  • Add Oracle Constraints – Primary, Foreign, Unique, Check, Null to Existing Table
  • Add or Insert a Heading Extra Line after Every nth Line of File in Unix / Linux
  • Adsense CPC Fluctuation / CPC Drop Reasons, Key Factors for CPC Improvement
  • Advantage of Caching / Pinning/ Keeping an Oracle Table in Buffer Pool
  • Benefits of Registering Own Custom Domains for Your Blog on Blogger or WordPress
  • By Pass the User Password Using Grant Connect Through clause
  • CAN FLASH to 111 Method to Disable / Stop / Turn off / Deactivate unwanted Vodafone Flash Messages
  • CHAR vs VARCHAR Difference, Advantage in Performance Tuning
  • Change the RMAN Backup TAG Retention Policy Using Change Backup .. Keep Command
  • Check Who is Accessing / Locking / Blocking the Oracle Session / Table
  • Choosing the best indexing strategy
  • Compress/zip Sqlplus Spool Output Automatically with Sql Execution Using UNIX Pipe
  • Connect to hanging database using sqlplus –prelim option in Oracle 10g, 11g
  • Convert Oracle Varchar2 column to Blob data type Using utl_raw.cast_to_raw – Example
  • Count & Remove Repeating / Duplicate lines in Linux/Unix file
  • Create File or Modify the Existing UNIX/LINUX File With Old / New Timestamp
  • Create Jpg, png, PDF Oracle Database Schema ER / Table Relationship Diagram Using Data Modeler
  • Create PFILE SPFILE from memory 11g New Feature
  • Create Synonym Failed with ORA-01471: cannot create a synonym with same name as object
  • Create a Case Sensitive Table in Oracle / Table Name in Lower Case
  • Creating indexes on Nullable Columns
  • Creation, Features of a global temporary table, Privileges to populate
  • DBMS_ROWID for Oracle ROWID Pseudo column Format. Structure, Purpose, Features
  • DBMS_SCHEDULER. Create_job Fails with ORA-06512 ORA-27486: insufficient privileges
  • DBMS_STATS.export import:How to transfer oracle statistics between databases
  • Data Guard / Standby: ORA-01156: recovery or flashback in progress may need access to files
  • Data Guard / Standby: ORA-01624: log %s needed for crash recovery of instance %s (thread %s)
  • Data Pump (expdp/impdp) Tuning features - PARALLEL option for faster performance behavior
  • Data Pump EXPDP : How to EXCLUDE table partition explained with example
  • Data Pump EXPDP Error: ORA-39181: Only partial table data may be exported due to fine grain access control on
  • Data Pump EXPDP FLASHBACK_SCN Parameter
  • Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options Features and examples
  • Data Pump EXPDP IMPDP Status Parameter for Feedback
  • Data Pump EXPDP IMPDP content=METADATA_ONLY to Extract the Skeleton of the Oracle Database
  • Data Pump Expdp ESTIMATE_ONLY Parameter
  • Data Pump Expdp Impdp Exclude Include Table Partitions – Table_data option
  • Data Pump Expdp Impdp Metrics=Y Undocumented Parameter
  • Data Pump IMPDP REMAP_SCHEMA Parameter Syntax and Examples
  • Data Pump IMPDP REMAP_TABLESPACE Parameter Syntax and Examples
  • Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE
  • Data Pump IMPDP failed: ORA-31655: no data or metadata objects selected for job and ORA-39154
  • Data Pump Impdp TRANSFORM option SEGMENT_ATTRIBUTES, STORAGE, OID and PCTSPACE examples
  • Data Pump Impdp show=y Replaced with SQLFILE Option
  • Data Pump expdp REUSE_DUMPFILE option: Overwrite existing dumpfile
  • Data Pump impdp expdp : SQLFILE option to extract DDL and DML from dump file
  • Data Pump impdp expdp Full, Schema, Table Level Export / Import Syntax with Examples
  • Data Pump impdp expdp NETWORK_LINK option : Transfer schema across database using db links without dump file!
  • Data Pump impdp remap_table Option to Change the Table Name During Import
  • Data Pump vs EXP/IMP: Difference or Comparison Between Data Pump Expdp/impdp and Conventional EXP/IMP
  • Data guard / Stand by: What are the Steps to Move Datafiles / Logfiles to Different Location?
  • Data pump IMPDP SKIP_UNUSABLE_INDEXES=Y/N Parameter Option Example
  • Database Recovery from Corrupted, Missing Redo, Archive Log Files Using _ALLOW_RESETLOGS_CORRUPTION, _CORRUPTED_ROLLBACK_SEGMENTS, _minimum_giga_scn and _allow_error_simulation
  • Database startup failing ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used,
  • Datapump IMPDP Partition_Options = MERGE , DEPARTITION Examples
  • Delete vs Truncate in Oracle 9i 10g 11g – Difference and advantages
  • Difference between BIGFILE and SMALLFILE tablespace, Advantages. How to Create and Resize Bigfile Tablespace?
  • Difference between LOG_ARCHIVE_DEST_1 LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST
  • Different Methods to Find Out Oracle Version From the Database
  • Different Methods to Print Single Quote (') in AWK programming
  • Different methods to find out NLS Parameters from Oracle Database
  • Different types of Oracle Partitioning Range, Hash, List, Interval
  • Duplicate Command Failed: RMAN-05001: auxiliary filename %s conflicts with a file used by the target database
  • EMCA dbconsole configuration failed with ORA-20001: SYSMAN already exists
  • EXADATA Smart Scan - cell_offload_plan_display = NEVER / AUTO /ALWAYS Parameter
  • EXPDP IMPDP Failed or terminated with ORA-31633, ORA-06512, ORA-00955
  • EXPDP IMPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033
  • Easy Methods to Find Out Oracle 9i 10g 11g DBID
  • Easy and quick way to get Google Plus invites. Steps to get Google Plus invitation from my blog
  • Error in invoking target ‘mkldflags ntcontab.o nnfgt.o’ of makefile net_client.mk: Oracle installation failed
  • Exadata Hybrid Columnar Compression – HCC : Comparison between Compress for Query High and Archive High
  • Example on Data Pump EXPDP IMPDP Parfile Option
  • Execute Immediate Command Fails with DBA role: ORA-01031: insufficient privileges
  • Expdp / Impdp Tablespace Parameter Benefits and Examples
  • Expdp Export Failed: ORA-00439: feature not enabled: Dump File Data Compression
  • Expdp/Impdp Transportable Tablespace Movement across Different OS Platforms in Oracle 9i, 10g, 11g Examples, Advantages
  • Expire Oracle User Password in Few Minutes Using Profile Resouces PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME
  • Explicit Vs Implicit Commit in Oracle– Difference and When it Occurs?
  • Export and Create Excel File from Oracle SQL Query Spool Output File
  • F4 Key to Repeat Last or Previous Action / Task in Microsoft Excel or Word 2007 and 2010?
  • FIX RMAN-11001 ORA-01547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"
  • Features and Advantages of Oracle 11gR2 Deferred segments – Segment Creation on Demand
  • Features and configuration of Oracle Automatic UNDO Management AUM
  • Find / Check Hot/Frequently Accessed Objects in Oracle 10g 11g Database Using v$db_object_cache
  • Find out Maximum, Current Limit of Oracle Resources (Session, Process, Lock) using v$resource_limit
  • Find out the Kochi Metro Railway Project Details Online
  • Find out the income tax (IT) ward/circle for income tax e-filing
  • FireFox: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser
  • Fix DB Link Error ORA-02085: database link connects to
  • Fix DGMGRL: Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
  • Fix Data Pump EXPDP Error ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
  • Fix Duplicate Database failing RMAN-06136: ORA-01618: redo thread is not enabled - cannot mount
  • Fix IMP-00013: only a DBA can import a file exported by another DBA
  • Fix IMP-00058: ORACLE error 1950 encountered
  • Fix ORA-01157: cannot identify/lock data file # - see DBWR trace file ORA-01110: data file #: ORA-01136: specified size of file # (n blocks) is less than original size
  • Fix ORA-01927: cannot REVOKE privileges you did not grant
  • Fix ORA-02032: clustered tables cannot be used before the cluster index is built
  • Fix ORA-02299: cannot validate (SCOTT.EMP_UK) - duplicate keys found
  • Fix ORA-08189: cannot flashback the table because row movement is not enabled
  • Fix ORA-09817: Write to audit file failed. SVR4 Error: 28: No space left on device
  • Fix ORA-10636: ROW MOVEMENT is not enabled Table Shrink Command Failed
  • Fix ORA-14400: inserted partition key does not map to any partition
  • Fix ORA-14402: updating partition key column would cause a partition change
  • Fix ORA-15097: cannot SHUTDOWN ASM instance with connected client (process %s)
  • Fix ORA-19870 ORA-19863: device block size 4186112 is larger than max allowed: 1048576
  • Fix ORA-38814: ALTER SESSION SET EDITION must be first statement of transaction
  • Fix Oracle 10g 11g Data Pump IMPDP Failed withORA-39002 ORA-06512 ORA-39070 ORA-29283: invalid file operation
  • Fix Oracle 11g Client sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
  • Fix Oracle 11g Database Block Corruption? - Recovery Using RMAN Backup ORA-01578: ORACLE data block corrupted
  • Fix RMAN Duplicate Database Failed with ORA-20 Connecting to ASM Instance
  • Fix RMAN Duplicate database failed ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [kdt.c], [9576], [11.2.0.2.0]
  • Fix RMAN-03009 ORA-00245 RMAN-08132 control file backup operation failed
  • Fix RMAN-04005 ORA-01031: insufficient privileges RMAN-00554 in Oracle 10g 11g RAC
  • Fix RMAN-04014 ORA-00439: feature not enabled
  • Fix RMAN-04014 ORA-07446: sdnfy: bad value '…/bdump' '…/udump'
  • Fix RMAN-06004 RMAN-20001: target database not found in recovery catalog
  • Fix RMAN-08138: WARNING: archived log not deleted - must create more backups
  • Fix RMAN-20242: Specification Does Not Match Any Archive Log
  • Floating Facebook Like, Share, Google Plus One +1 Button Gadget HTML Code For Blogger
  • Functions and Features of Oracle UNDO
  • Generate Random Date between Dates or Period Using Julian Date and DBMS_RANDOM package
  • Get Timestamp from SCN in Oracle 10g 11g? Convert SCN to Timestamp Using scn_to_timestamp and timestamp_to_scn
  • Global Index Vs Local index – Difference, Advantages, Disadvantages, features, examples
  • Google Animated Music Doodle on Valentine’s Day 2012
  • Google Chrome: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser
  • Google Language Translator Gadget HTML Code: With Small Beautiful Flags for Blogger
  • Google Page Rank (PR) Latest Recent Update Happened on 04 Feb 2013
  • HISTTIMEFORMAT: How to See the Linux commands History with Date and Time?
  • HTML Code to Place Adsense Ads Side by Side, Left, Right, Center Aligned on Blogger Posts
  • How Can I Get vi Editor Commands History
  • How long needed For Google Adsense Approval for Blogspot? I Got In 2 Months for my new blog! 10 Guaranteed Tips!
  • How the Optimizer chooses Between Indexes and Full-Table Scan
  • How to Add / Install RSS Feedburner Reader Counter to Blogger?
  • How to Add / Install Syntax Highlighter for Scripts in Blogger Post – SQL, Java, Python, HTML etc
  • How to Add or Insert Current Log Time and Date to a Notepad File Or Whenever You Open the file by Default
  • How to Append Command Outputs To Oracle SQLPLUS Spool File
  • How to Append Extra New Records to Table Using Oracle SQL loader?
  • How to Automate / Schedule Oracle Gather Table Statistics Job through Crontab?
  • How to Avoid / Remove Adsense Ads from Homepage / Archive Page in Blog
  • How to Avoid / Stop /Restrict the Dropping of User Schema by Mistake from Oracle Database?
  • How to Bypass DROP ANY TABLE Privilege for Truncate Table Command
  • How to Change / Move Oracle Inventory Location to another Directory?
  • How to Change Oracle 11g 10g RAC database to Noarchivelog mode?
  • How to Change Oracle 9i 10g 11g Database Time_Zone? Fix ORA-02231 & ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE (TSLTZ) columns
  • How to Check / Find out the Privileges and Roles for My Own Session Oracle
  • How to Check / Find the Oracle Table Depended Objects?
  • How to Check AWR Snapshot Setting using SQL Queries?
  • How to Check Oracle 9i, 10g, 11g Scheduler Jobs Status
  • How to Check What is Getting / Being Audited in Oracle Database?
  • How to Check Whether the Oracle Database is Using Pfile or SPfile?
  • How to Check Which Child Directory is consuming More Space in Unix/Linux?
  • How to Check and Find Out PF Account Balance and Details online? Portal Lauched on 01-07-2011with SMS
  • How to Check the Current Oracle Session Connected to which User or Schema? 3 different methods
  • How to Check the Number of Concurrent Users in the Oracle Database Dynamically?
  • How to Configure Tablespace / Monitoring Alert Emails in Oracle 11g OEM Rules
  • How to Convert the AIA xref_data Cross Reference table LAST_MODIFIED, LAST_ACCESSED to Date?
  • How to Copy File without Changing Last Modified Date, Time stamp and ownership in Linux / Unix?
  • How to Copy Only New / Modified / Changed Files in Unix / Linux?
  • How to Create Case Sensitive Password File in Oracle 11g?
  • How to Create Different Editions or Versions for Oracle Objects? Its Advantages
  • How to Create Virtual Columns with Oracle 11g New Feature?
  • How to Create a Fixed Huge Size File in Unix / Linux Using dd Command?
  • How to Delete / Drop All the Tables in One / Multiple Oracle 10g 11g Schema
  • How to Disable / Escape / Avoid / Stop & and && Variable Substitutions in Oracle SQL Plus
  • How to Disconnect or Expire the Idle Oracle 10g 11g Sesssions Automatically Using Profile IDLE_TIME Resouce
  • How to Drop Datafile from Tablespace on Oracle 8i, 9i, 10g, 11g Database?
  • How to Drop Oracle 10g 11g Bin$ / Recycle bin Tables
  • How to Exclude MLOG$ Materialized View Log Tables from the Data Pump IMPDP
  • How to Extract / Get Script for DBA_, V$ Oracle Data Dictionary Views?
  • How to Find Out Last Modified Time of a Row in an Oracle 10g 11g Table Using ORA_ROWSCN and SCN_TO_TIMESTAMP Functions?
  • How to Find Out Oracle Trace File Name for TKPROF or backup controlfile to trace?
  • How to Find Out Your Current / Own Oracle Session ID - SID?
  • How to Find out / Check / Set Values for Hidden Underscore _ Parameters in Oracle?
  • How to Find out / Identify the list of Schema / Users Available Inside a expdp data pump .dmp dumpfile
  • How to Fix ORA-20005: object statistics are locked (stattype = ALL)
  • How to Fix PLS-00201: identifier 'DBMS_AQ' must be declared
  • How to Force Oracle RMAN to Delete All Archive log files
  • How to Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database
  • How to Hide / Disable / Enable DISQUS AROUND THE WEB Discovery ads?
  • How to Hide / Disable / Remove DISQUS Discovery “ALSO ON” YOUR SITE feature?
  • How to Hide / Remove ‘Subscribe to: Post Comments (Atom)‘ From the New Blogger Interface 2013
  • How to Identify / Check / Find out Oracle .dmp dumpfile is Taken Using Exp / Expdp – Data Pump
  • How to Identify Connected Database Instance is Primary or Standby?
  • How to Keep / Pin / Check PLSQL Objects in Buffer Cache / Memory Using DBMS_SHARED_POOL.KEEP
  • How to Kill or Resume [1]+ Stopped Unix Jobs
  • How to Login with more than One (Multiple) Yahoo Messenger simultaneously?
  • How to Modify / Set SQLPlus Prompt With Connected Username and SID?
  • How to Open and Save UNIX / Linux man Pages to vi Editor File?
  • How to Pay Kerala Electricity Bill Online? Introduced New System from 23-April-2013
  • How to Perform Multiple Comparisons in Oracle SQL Query Using Select .. Case .. When .. Else
  • How to Perform a Date Test Case with Old or Upcoming Sysdate in Oracle? - FIXED_DATE Parameter
  • How to Prepare awk Data Report? Example
  • How to Query / Generate Multiple Rows from Oracle DUAL Table?
  • How to Recover / Restore / Recreate Dropped Dual Table in Oracle? ORA-01775: looping chain of synonyms
  • How to Recover the Oracle 10g 11g Database from RMAN Cold Backup
  • How to Refresh / Recalculate Microsoft Excel Column Formula Automatically
  • How to Remove / Hide / Disable Google Plus One +1 Button from Adsense Image Ads
  • How to Remove / Hide Post Counter from Blogger Archive Widget in New Interface
  • How to Rename Oracle 11g 10g Database Using NID command Line Utility
  • How to Rename Tablespaces to a New name in Oracle 9i 10g 11g ?
  • How to Rename an Unnamed datafile (UNNAMED00004) to Original Name in Oracle 9i 10g 11g Standby Database?
  • How to Renew the Domain Registered From Blogger Settings – Domain Auto Renewal via Google Apps
  • How to Restore Oracle RMAN Backup from Previous or Old Incarnation
  • How to Run / Schedule a PLSQL Procedure In Shell Script and Crontab?
  • How to Run Expdp Impdp Jobs in Background
  • How to Schedule / Execute / Run an Oracle Procedure through DBMS_JOB?
  • How to See the Oracle 10g 11g Bind Variable Values Using v$sql_bind_capture
  • How to Set / Fix / Limit the Oracle 10g 11g Trace File Size
  • How to Set / Unset Default Value for Command Line Arguments For a shell script?
  • How to Share / Add / Embed Youtube Video to Blogger Posts?
  • How to Signup and Install / Add Google Analytics Code to Your WordPress / Blogger Blogs?
  • How to Terminate Data Pump EXPDP IMPDP Executing Jobs exited without KILL_JOB command?
  • How to Use Drop Database Command in Oracle 11gR2?
  • How to Use ORADEBUG CURRENT_SQL to See Other Session SQL
  • How to Use ORADEBUG to Find out Trace file name
  • How to apply for Government Cards online – PAN, TAN, Ration, Passport, and Electoral
  • How to change or modify the SQLPlus prompt?
  • How to check file last modification or change date and time details in Linux?
  • How to check flash recovery area USAGE for oracle(10g, 11g) database?
  • How to check patches applied on oracle database? Patch history details
  • How to check the pending transaction in your oracle session?
  • How to check whether oracle is 32bit/64bit and running OS platform is 32bit/64bit?
  • How to compress export (exp) dump files using UNIX pipes?
  • How to configure or setup Flash Recovery Area to an Existing oracle (10g, 11g)Database?
  • How to correct & fix the corrupted Oracle (9i, 10g, 11g) inventory using runInstaller & opatch?
  • How to create and remove soft link (symbolic) in Solaris AIX?
  • How to create dummy NULL column for a Oracle view using function?
  • How to disable all constraints on a table or schema - Oracle sql Script
  • How to disable flash recovery area of existing open Oracle (10g, 11g) database?
  • How to enable voice call in Microsoft Office Communicator 2007 R2 Windows 7 and XP
  • How to encrypt UNIX (solaris AIX Linux) files using vi editior? Protect your UNIX files with password
  • How to find / Set NLS_LANG in Solaris AIX Unix and Windows for Oracle?
  • How to generate/spool index creation script for a schema using dbms_metadata.get_ddl?
  • How to generate/spool table creation script for a schema using dbms_metadata.get_ddl?
  • How to get Google Analytics Code again?
  • How to hide oracle passwords - sqlldr, sqlplus, exp, imp, expdp, impdp from Unix ps command?
  • How to install an application from iTunes to iPhone
  • How to install/apply/change XML template on new blogger interface
  • How to move oracle datafile to different location and rename?
  • How to open a crashed oracle database during HOT BACKUP
  • How to read (command) without enter in Linux bash shell?
  • How to rename Oracle Database? Recreate oracle controlfile: Steps to rename the database
  • How to rename and move a oracle system tablespace datafile?
  • How to schedule a Unix shell script in crontab to run every 2nd Saturday(nth Day of the month)
  • How to search Unix files pattern recursively (subdirectory) with file size
  • How to see / Check the Step by Step Execution of a Shell Script for Debugging?
  • How to setup Oracle 11g, 10g Transparent Data Encryption - TDE? Advantages, SALT Option
  • IMPDP EXPDP ENCRYPTION_PASSWORD Parameter ORA-39173: Encrypted data has been stored unencrypted in dump file set
  • IMPDP FLASHBACK_SCN, FLASHBACK_TIME Shows in Parameter Help – Is it a bug?
  • Implement Delay or Sleep in Oracle PL SQL Scripts Using DBMS_LOCK.SLEEP?
  • Index Rebuild Failed With ORA-14456: cannot rebuild index on a temporary table
  • Index Rebuild Online Failed Oracle 11gR2: ORA-01450: maximum key length (3215) exceeded
  • Insert, Delete, Truncate Operations with Oracle Dual Table. Just Not Fun
  • Interesting Features of Oracle TO_DATE and TRUNC Functions
  • Internet Explorer: Uninstall / Disable / Remove Yahoo Axis Search Bar from IE Browser
  • Invoke Data Pump EXPDP IMPDP export / import Using SQL Developer
  • Les Paul Interactive Music Google Doodle – With record option still available with doodle collection
  • Main Reasons for Delay or Not Receiving the Adsense PIN after a Period of Time
  • May 1st 2013: New IRCTC Train Advance Ticket Reservation Booking Period (ARP) is 60 Days
  • Move Subpartition for an Interval Partitioned Table Failed: ORA-00600 [kkpod nextFrag]
  • No More New PayPal Donate Buttons for Indian Bloggers / Users
  • NoMachine Tool: Better Remote Desktop Connectivity across Different OS platforms
  • OC4J Connection Pool Error Message: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
  • OPatch fails with wrong platform ID (610, 212)
  • ORA-00059: maximum number of DB_FILES exceeded - Fix / Resolve Oracle Add Datafile Error
  • ORA-00214 control file flash_recovery_area version %s inconsistent with file version %s
  • ORA-01548: active rollback segment, Find out Oracle 10g 11g Active Undo Segments from system datafile
  • ORA-01732: data manipulation operation not legal on this view
  • ORA-04031: unable to allocate 2048024 bytes of shared memory: 11 g RAC Fix error
  • ORA-06502: PL/SQL: numeric or value error: raw variable length too long: Convert Varchar2 to Blob with utl_raw.cast_to_raw
  • ORA-10662: Segment has long columns, Table Shrink Command Failed: Workaround
  • ORA-20021: database not set: Select From RC_BACKUP_FILES Table failed
  • ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 2: No such file or directory
  • ORA-28001: the password has expired - Permanent Fix for NOEXPIRY for Oracle User
  • ORA-28011: the account will expire soon; change your password now
  • ORA-28150: proxy not authorized to connect as client
  • ORACLE BASE Vs ORACLE_HOME - Difference between ORACLE_BASE and ORACLE_HOME
  • OS error in starting service OracleMTSRecoveryService: Oracle 11gR2 Installation Fails
  • OUI-10094:Problem in saving inventory. Current access level does not allow writing to the inventory
  • One More Interactive Music Doodle from Google: Happy Holidays 2011
  • Opatch Failed error code 73: OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables"
  • Oracle 10g 11G RAC Database Control File Creation Failed with ORA-01503, ORA-12720: operation requires database is in EXCLUSIVE mode
  • Oracle 10g 11g Archivelog Vs Noarchivelog Mode Difference, Advantages, Features
  • Oracle 10g 11g Data Pump EXPDP Query Parameter option
  • Oracle 10g 11g Data Pump EXPDP SAMPLE Parameter Option
  • Oracle 10g 11g RAC ASM RMAN Database Cloning to Different Server with Different File System
  • Oracle 10g 11g RMAN Useful Commands
  • Oracle 10g 11g Shared Database – DB Link – Features, Advantages and Disadvantages
  • Oracle 10g 11g Syntax for Lock and Unlock a User Schema Account
  • Oracle 10g, 11g User Password Last Modification / Reset time - sys.user$
  • Oracle 11G SQL Command Syntax to Check Free Space, Shrink Temporary Tablespace or Tempfile
  • Oracle 11g 10g Database SQL Script to Find Out Active Sessions Waits
  • Oracle 11g 10g RMAN Duplicate Database Command Using TAG: How to Clone a Database in same server / node
  • Oracle 11g : Read-Only Tables New Feature & advantages
  • Oracle 11g ADRCI - Configure and Setup Automatic Diagnostic Repository Using Command Line Interpreter
  • Oracle 11g ADRCI – How to Create Package for an Incident or a Problem?
  • Oracle 11g ASM (Automatic Storage Management) Features, advantages and benefits
  • Oracle 11g Automatic Diagnostic Repository – ADR – Features and advantages
  • Oracle 11g Data Pump expdp compression option to reduce the export dump file
  • Oracle 11g Database Startup Failed: /dev/shm and ORA-00845: MEMORY_TARGET not supported on this system
  • Oracle 11g Enable Case Sensitive Passwords For Improved Password Security
  • Oracle 11g LMon RAC Background Process Functions
  • Oracle 11g New Feature : Advantage of Shrink Temp Tablespace and Tempfile
  • Oracle 11g New Feature : SQLPlus Error Logging Features and advantages
  • Oracle 11g New Feature Parameter DDL_LOCK_TIMEOUT : DDL waiting time for DML Locks
  • Oracle 11g New Feature password security dba_users password column is null and stored in user$
  • Oracle 11g New Feature: Invisible index advantages for performance tuning
  • Oracle 11g ORA-12916: cannot shrink permanent or dictionary managed tablespace; Oracle Tablespace Shrink Command Failed
  • Oracle 11g Password : Relation between user$, DBA_USERS, PASSWORD_VERSIONS, spare4, IDENTIFIED BY VALUES
  • Oracle 11g RESULT_CACHE Hint : Faster Performance Queries, Advantages, Benefits
  • Oracle 11g Security SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter
  • Oracle 11g User Account Status LOCKED(TIMED) with FAILED_LOGIN_ATTEMPTS, PASSWORD_LOCK_TIME Parameters
  • Oracle 11gR2 Impdp DATA_OPTIONS SKIP_CONSTRAINT_ERRORS: How to Skip Constraint Errors during Import?
  • Oracle 11gR2 Installation Prerequisite Checks Failed on Windows XP
  • Oracle 11gR2 LISTAGG Analytical Function – Concatenate / Select Multiple Rows of a Table to Single
  • Oracle 11gR2 NTH_VALUE Function Usage Syntax
  • Oracle 11gR2 NTILE Analytic Function Usage Syntax
  • Oracle 11gR2 SQLPlus SET EXITCOMMIT ON/OFF
  • Oracle 11gR2 relink new feature
  • Oracle 11gR2: Generate Number Series Using Select Command with array(x) as clause? UNDEF Command to Reset && variable
  • Oracle 11gR2: Truncate Drop Storage Vs Drop All Storage Clauses
  • Oracle 12c Data Pump EXPDP IMPDP Logtime Option Parameter
  • Oracle 9i, 10g, 11g: Methods to Rename a username / schema to a new name
  • Oracle ASM Datafile add / resize failed with ORA-01237 ORA-01110 ORA-17505 ORA-15041: diskgroup "DATA" space exhausted
  • Oracle Cast Function: ORA-01438: value larger than specified precision allowed for this column
  • Oracle Create Table Syntax: 19 Different Examples
  • Oracle Create View Syntax: 9 Different Examples
  • Oracle Create table, Materialized View Command Fails with ORA-01723: zero-length columns are not allowed
  • Oracle DBMS_RANDOM Package to Generate Random Numbers, Strings
  • Oracle Data Pump (expdp/impdp) Benefits / Advantages & Disadvantages
  • Oracle Data Pump EXPDP IMPDP REMAP_DATA Parameter for Data Transformation with Example
  • Oracle Data Pump expdp impdp Use JOB_NAME Option to Stop_job, Attach, Kill_job and Continue_client interactively
  • Oracle Delete and Update Commands Executes With Set Autotrace Traceonly Explain
  • Oracle EM Alert: Critical:DBNAME - There have been n failed login attempts in the last x minutes: Identify the LOGIN failure with 1017 returncode
  • Oracle INDEX hint : Different usage syntax for performance tuning
  • Oracle Imp show=y & Indexfile: How to generate sql scripts from Oracle dump file?
  • Oracle Kill Session Command Fails with ORA-00027: cannot kill current session
  • Oracle NO_INDEX hint: Syntax, Purpose and Example
  • Oracle Private vs Public Synonyms – Advantages Difference and Features
  • Oracle RAC Startup failed ORA-01102: cannot mount database in EXCLUSIVE mode
  • Oracle SQL Loader Bad file (.bad) Parameter Example
  • Oracle SQL Query to Find out Cumulative SUM and Duplicate Rows of a Table Records
  • Oracle SQL Query to Find out Nth Largest, Highest, Lowest, Smallest Values
  • Oracle SQL Query to Print / Display Calendar Using 11gR2 LISTAGG Function
  • Oracle SQL Script to Compile All Package, Body in a Schema
  • Oracle SQL Script to Find Out Active Sessions Details
  • Oracle SQL Select Statement / Function to get Server Memory, CPU and Processor details
  • Oracle SQL to Check the Database / Instance Name to Which the Current Session Is Connected using a Non DBA user
  • Oracle SQLPlus Copy Command Usage Syntax to Copy tables across database
  • Oracle Upgrade Catupgrd.sql failed: with SELECT TO_NUMBER('MUST_BE_11_2_0_3') FROM v$instance
  • Oracle User Password Reset : Two different methods – SQL*Plus and alter user
  • Oracle V$ vs RAC GV$ Dynamic Performance Views – Difference and Features
  • Oracle Views vs Materialized Views – Difference, Advantages, Disadvantages and Features
  • Oracle Views vs Tables- Advantages, Disadvantages and Features
  • Oracle dbms_utility.get_dependency to Get Dependent Objects or Dependencies of a Table
  • Oracle exp compress=Y Compress option in export (EXP) utility
  • Oracle int vs number datatypes difference and features
  • Prepare / Generate repetitive SQL Scripts Using Microsoft EXCEL CONCATENATE Function
  • Procedure to Apply and get OCP Certificate and Logo who Completed Exams Hands on Training
  • Public Database Link fails with ORA-12154: TNS:could not resolve the connect identifier specified
  • Purpose of ADR_BASE_Listener & DIAG_ADR_ENABLED_listener : Oracle 11gR1 Listener ADR Parameter
  • Purpose of ORAENV_ASK=NO / YES variable in Oracle
  • RMAN Configure Backup Optimization ON / OFF : Features & Example
  • RMAN Duplicate Database Failed with RMAN-06136, ORA-15001: diskgroup "DATA_CEX" does not exist or is not mounted
  • RMAN Point in time Recovery (PITR) scenario of a dropped oracle tablespace
  • RMAN Reset Incarnation Failed: ORA-19910: can not change recovery target incarnation in control file
  • RMAN Switch command script to rename the datafile
  • RMAN-06059 ORA-19625 backup archivelog all delete input
  • Reason and Fix for ORA-25153: Temporary Tablespace is Empty
  • Reason for ORA-00439: feature not enabled: Partitioning
  • Reasons and Workarounds to Fix ORA-00997: illegal use of LONG datatype
  • Reasons for ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
  • Reasons for PL/SQL Code Block Failure with ORA-01001: invalid cursor
  • Relation / Difference : O7_DICTIONARY_ACCESSIBILITY = TRUE / FALSE, SELECT ANY DICTIONARY, SELECT CATALOG ROLE and SELECT ANY TABLE
  • Rename Command fails with ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
  • Rename Oracle 9i, 10g, 11g Datafile with Blank Space/White Space/Special/New line Characters
  • Replace SQL Null Values with SQLPLUS Set Null Command
  • Reset the Password for an Oracle Expired Login or Username to Old or Previous Value
  • Reset/Modify/alter Oracle sequence nextval, currval to new value without dropping
  • Restrict the commands (SELECT DELETE UPDATE) in SQL*PLUS for a particular user
  • Retrieve / Recover / Restore Dropped Table in Oracle 10g 11g Using Flashback Table Feature
  • SET AUTOTRACE EXPLAIN or EXECUTION Plan Options
  • SQL Developer, Data Modeler Failed: Unable to Launch the Java Virtual Machine Located at Path:
  • SQL Loader bad file vs Discard File: Difference and Examples
  • SQL Query Check Oracle (9i/10g/11g) tablespace free space and space Usage
  • SQL Syntax to Add Offset Hour, Minute, Year, Day, Month to Oracle Timestamp Values Examples
  • SQL*Loader DISCARDMAX Parameter
  • SQL*Loader PARFILE Parameter
  • SQLPLUS Connect, Startup Fails with ORA-09925: Unable to create audit trail file SVR4 Error: 13
  • SQLPLUS: Create Spool File with DB Schema Name and Current Time and Date/Sysdate
  • STOP / Disable Oracle 11g ADDM, AWR using control_management_pack_access Parameter
  • Script to Find out SQL Text from Oracle 11g, 10g RAC Database Using SID, SPID
  • Script to Generate and Spool DDL / SQL statements for Tablespaces in Oracle 10g 11g Database
  • Script to increment or decrement all sequences in a schema by n=1000 numbers
  • Select Failed with ORA-00980: synonym translation is no longer valid
  • Select from System Package DBMS_METADATA Failed: ORA-25153: Temporary Tablespace is Empty, ORA-06512
  • Shell Script to Execute Oracle Sql Script in Crontab for a Specified SID
  • Shell Script to Print Only First / Last Words in all Lines of a Text File
  • Shell Script to Repeat the Execution of Command / Job Based on Time Interval Periodically
  • Shell Script to Run RMAN Backup in Background with nohup
  • Shell Script: 3 Methods to Find Out Nth Word in a String
  • Shell Script: Different Method to Find Out Number of Characters in a String
  • Siebel Database Configuration Failed: C102: The Username / Password Combination.00000: cannot be validated at this
  • Siebel Error SBL-ODC-00105 ORA- 24345 A Truncation or null fetch error occurred
  • Simple Page Navigator for Home and Archive Blogger Pages with Numbers and Customization Tricks
  • Soft Link Vs Hard Link in Solaris & AIX Unix OS – Difference and Features
  • Solaris psrinfo to check number of CPU/processors SunOS
  • Steps for RMAN Recovery from Old Incarnation without Catalog
  • Steps to Configure Oracle 11g 10g RMAN Catalog in Same / Different Database
  • Steps to configure Oracle 11g OEM DBConsole manually for an existing database
  • Syntax to Find / Check / Change / Set Default Permanent Tablespace for Oracle 10g, 11g Database
  • Syntax to Find / Check / Change / Set Default Temporary Tablespace for Oracle 10g, 11g Database
  • Take / Generate Oracle 10g 11g Active Session History Report (ASH) Manually
  • Tested Tips to Increase or Improve Adsesnse CTR
  • Trace an Oracle session? DBMS_SYSTEM, DBMS_SUPPORT
  • Traffic after Registering Custom Domain for Blogger Blogspot - My Experience
  • Transfer Oracle ASM binary Files One File System to another File System Using DBMS_FILE_TRANSFER
  • Trick to HIDE / Mask Oracle User Password in Alter User Command?
  • Troubleshoot & Fix ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • Troubleshoot & Fix RMAN Duplicate Database failed with RMAN-11003 & ORA-19906
  • Troubleshoot & Fix RMAN Duplicate database Failed RMAN-00600: internal error, arguments [8546] [1]
  • Troubleshoot & Fix RMAN Duplicate database failed with ORA-12720 RMAN-06136
  • Troubleshoot & fix ORA-01002: fetch out of sequence
  • Troubleshoot Fix EMCA CONFIG: emca/emcaDbUtil: perl/bin/perl: not found
  • Troubleshoot Fix EMCA Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) ORA-01031: insufficient privileges
  • Troubleshoot Fix IMP-00010 not a valid export file header failed verification
  • Troubleshoot Fix ORA-16018 ORA-16019 ORA-02097 Oracle Archival Errors
  • Troubleshoot Fix Resolve ORA-00054: resource busy and acquire with NOWAIT
  • Troubleshoot Fix Resolve ORA-00060: deadlock detected while waiting for resource
  • Troubleshoot Fix Resolve ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed
  • Troubleshoot Fix Resolve ORA-01555:snapshot too old: rollback segment number %s
  • Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded
  • Troubleshoot Fix emca oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener
  • Troubleshoot Fix error IMP-00038: Could not convert to environment character set's handle
  • Troubleshoot Fix unrecoverable error ORA-29701 raised in ASM I/O path; terminating process 17946
  • Troubleshoot ORA-00938: ORA-00939: not enough arguments & too many arguments for function
  • Troubleshoot and fix TNS-12560 TNS-00583: Valid node checking: unable to parse configuration parameters
  • Troubleshoot fix ORA-28368: cannot auto-create wallet ORA-28353: failed to open wallet
  • Troubleshoot fix resolve ORA-00936: missing expression
  • Troubleshoot fix resolve ORA-04091: table scott.EMP is mutating, trigger/function may not see it
  • Troubleshoot fix resolve ORA-12988: cannot drop column from table owned by SYS. How to drop a column of a table owned by SYS
  • Truncate Failed: ORA-03292: Table to be truncated is part of a cluster
  • Truncate failed ORA-24005: Inappropriate utilities used to perform DDL on AQ table
  • UNIX: How to find out the total size of files from multiple directories
  • Unable Access Password Protected Spread Sheet / Document Google Drive On iPhone
  • Unique Index Creation Failed: ORA-12801: error signaled in parallel query server P018, instance
  • Unix Shell Script to Find out Files Created within x Hours Without Using mmin / cmin for Solaris
  • Unix: Command to check swap space in Solaris & AIX?
  • Unix: Command to kill multiple processes (pid) in single command
  • Unix: How to find out most CPU consuming processes?
  • Unix: command to check physical memory (RAM) in Solaris & AIX
  • Usage syntax for Oracle 10g REGEXP_LIKE regular expression function
  • Use dbms_xplan.display_awr to Pull Full SQL and Execution Plan for a Query in AWR
  • Using vi, awk, sed - erase / remove / cut Few First , Last Characters in all lines of Linux file
  • Validate Exception Queue: ORA-24017: cannot enable enqueue on QUEUE
  • WDYL : New Google Multi Search Feature : What Do You Love
  • What are the Advantages / Benefits / Features of Oracle SQL loader?
  • What are the Considerations for EXADATA Smart Scan Cell Offloading?
  • What are the Oracle Advanced Data Compression methodology Tips?
  • What is CLRExtProc, PLSExtProc and extproc in Listener.ora? Why actual database SID is not mentioned in listener.ora by default?
  • What is Data Pump Expdp SOURCE_EDITION and Impdp TARGET_EDITION Options? Examples
  • What is Oracle 11g Problems and Incidents Concept?
  • What is Oracle BBED Tool? How to make it Available in Oracle 11g?
  • What is Oracle memory HIT and Memory Miss? Buffer Cache, Library Cache, Dictionary Cache HIT Ratio
  • What is the Difference between Digital Receiver Type DVBS and DVBS2?
  • What is the command to take Oracle Control file backup? Standby Control file, ASCII control file
  • What is the datatype and precision of Oracle NULL column?
  • What is the significance of Oracle Parameter Global_names=TRUE?
  • Why Adsense Ad Slots are Blank / Empty – Main Reasons
  • Why Oracle DBA_TEMP_FILES view Bytes Column is NULL: How to Drop, Shrink Offline / Online Temp File
  • Will IGNORE=Y Option Work with Data Pump IMPDP
  • Will Oracle Unique Key Constraint Allow / Accept more than One NULL Value?
  • Windows ORAKILL utility usage-Syntax to Kill Oracle thread
  • Without WWW Blogger Blogspot Domain is not Working- “Not Found 404”
  • Work Around for ORA-00600: [kkpo_rcinfo_defstg:objnotfound], [75312]
  • Workaround for ORA-600 [k2vpci_2] SMON Crash and Subsequent startup fails
  • cp , ln Commands to Create soft Links for all Files in Linux / Unix Directory
  • crontab Commands Fails in Linux: You (%s) are not allowed to use this program (crontab)
  • dbms_lob.write Failed with ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
  • dbms_stats.gather_table_stats : ORA-00600: internal error code, arguments: [smboPut:fixedlen2]
  • dbms_system.ksdwrt Procedure to Write Custom Messages to Oracle Alert and Trace Files Manually
  • file not found dbhome_1\oc4j\j2ee\oc4j_applications\applications\em.ear – Oracle Installation failed
  • opt_param ( 'cell_offload_processing' , ’TRUE/FALSE’ ) Hint to Enable EXADATA Smart Scan Feature: Speed Comparison with Smart Scan
  • userenv('ISDBA') : To check the Current Oracle Session has DBA Privilege
  • vi editor mark to create a sub file from main file: explained
  • vi, awk, sed - Substitute / Replace Few First , Last Characters in all lines of Linux file
  • what is ORA-00031: session marked for kill , ALTER SYSTEM KILL SESSION, resource busy and acquire with NOWAIT
  •  

    dba topics. Copyright 2011-14 All Rights Reserved | Site Map | Contact | Disclaimer