- SQL scripts for index monitoring and statistics in Oracle
- SQL scripts for indexes and partitioning in Oracle
- SQL Scripts for Indexes and Constraints in Oracle
- SQL Scripts for Index Maintenance and Alterations in Oracle:
- SQL Script for Index Recommendations and Analysis in Oracle:
- SQL scripts for index statistics and monitoring in Oracle
- Script to Generate Index Rebuild Scripts for Heavily Fragmented Indexes
- Script to Analyze Index Fragmentation and Generate Maintenance Scripts
- Oracle SQL Script to Check Index Fragmentation and Maintenance
- Oracle SQL Script for Index Usage and Performance:
- Oracle SQL Script to Retrieve Index Information - with Description and Sample Output
- Script to Analyzes the Efficiency of Indexes in an Oracle Database:
- RMAN Script That Incorporates Various Backup and Recovery Operations
- RMAN Archive Log Backup Script
- RMAN Script For Incremental Backup
- RMAN script for performing a full database backup
- Script to Find Active Sessions in an Oracle Database
- Script to Identify and Resolve Blocking Sessions in Oracle Databases
- Script: Efficient Session Monitoring Techniques for Oracle DBAs
- Script: Effective Tablespace Usage Monitoring for Oracle DBAs
- Nokia G42 5G and Nokia G310 5G: Exciting New Smartphones Set to Debut with Enhanced Connectivity
- Genshin Impact 3.8 Livestream: Exciting Updates and Codes Revealed
- MLB The Show 23 Update 10: Patch Notes and Exciting Changes
- Can I download Microsoft Bing Read Aloud Audio to MP3 Format?
- Google Pixel Feature Drop Brings Exciting Enhancements and New Functionality
- Apple Enhances Podcast Discovery with New Subcategories and Search Functionality
- Unraveling the Ancient Artistry: Neanderthal Finger Marks Found on Cave Walls
- Hell Let Loose Update 1.019: What's New in the Latest Release
- Missing Titanic Submarine Operated by Video Game Controller: The Rise of Gaming Technology in Military Operations
- Rogue Company Patch Notes 2.25 Update: Exciting New Features and Improvements
- Nikon Unveils Two Exciting New Lenses: Introducing the Nikkor Z 180-600mm and More
- NoiseFit Crew Pro Smartwatch: A Feature-Packed Wearable for an Active Lifestyle
- Unveiling a Year-Long Cyber Attack: Insights into RDStealer Malware and RDP Brute-Force Attacks
- The Rise of Generative AI in Journalism: Transforming the News Landscape
- Aatmaj Healthcare IPO and the Buzz in the Primary Market: Key Details and Subscription Status
- From Gaming to Deep-Sea Exploration: The Surprising Role of Video Game Controllers in Submarines
- Meta's Potential Rivalry with Twitter: A Closer Look at Mark Zuckerberg's Strategy
- BepiColombo's Third Mercury Flyby: A Captivating Journey through the Inner Solar System
- Xiaomi Pad 6: A Feature-Rich Tablet at an Affordable Price
- Unlocking the Potential of Progressive Web Applications (PWAs): Boost Performance and Decision Making
- Shiny Sunkern in Pokémon GO: Unlocking Its Potential
- Supercharge Your Workflow with Google Keep: Tips and Tricks
- Unveiling the Latest Tablet Offerings: Redmi Pad 2, Realme Pad 2, and Alleged Xiaomi Pad 6 Pro
- The Perfect Yoga Companion: How the Apple Watch Enhances the Yoga Experience
- Exploring Business Strategies and Growth Prospects in the Yoga Clothing Market
- Tesla Semi Production Challenges: Addressing Recall Notice and the Future of Electric Trucks
- Query to Check Installed component in the oracle database?
- Purge AWR Snapshots Manually from Oracle Database
- SQL Query to Find Out the Locked Objects and Type of Lock
- Script to Get the Most CPU Consuming Sessions from Oracle Database
- SQL Query to Find Out Hourly Redo Log Generation
- Fix Dell Latitude Laptop Speaker Volume is Very low for zoom, skype etc
- Sql Query to Check Different Client Character Set, Client Version and Client Driver or Software Connected to The Database
- Query to Get Hostname Instance Name and Startup Time for Oracle RAC Database
- How to Check Active Transaction in Oracle Database – v_$transaction
- SQL Query to Find Out Session wise PGA Usage
- SQL Query to Find Out Sessions Using More Temp Space
- Easy way to Connect and Query OCI Autonomous Database - SQL Developer Web
- How to Create or Provision OCI Autonomous Database
- Script to Check ASM Diskgroup Compatibility
- Script to Check Disk group Freespace & Mount Status
- SQL Script to Check Disk Group & Disks Details
- SQL Script to Find out ASM Disk Details
- Direct Method to Create Database Link Without Using TNSnames.ora
- SQL Script to Check Oracle Logfile Size, Status and Location
- Database Creation using dbca failed with Oracle Net Services configuration failed. The exit code is 1
- netca command failed with ProfileException: Could not create Profile: TNS-04414: File error
- India Driving License Renewal New Process Through sarathi.parivahan.gov.in/ Portal
- Scripts to Check RMAN Backup Status and Progress
- Datapump expdp impdp New Feature – Print Content of Parfile to Logfile
- Connect to Oracle Database Running in Linux
- Script to Check ASM Disk Usage Details
- Execute Oracle SQLs from Linux Command Prompt and Exit
- Command to List the Oracle Databases Running on Linux Server
- Commands to Delete Old Aged Oracle Trace Files(.trc, .trm) and Audit(.aud) Files
- Create Restore and Drop Oracle Restore Point - Types and Benefits
- RMAN: Dropped Table Recovery
- Script to Analyze All Schema Tables and Indexes in Oracle Database
- SQL to Set Tablespace Quota for Oracle User
- Script to Find out / Identify Trace File for the Current or Other Oracle User Session
- Trace Current Oracle Session – Different Methods
- SQL Query to Find Blocking Sessions and SQL Text for Last One Day from History
- SQL Query to Find SQLIDs Spend on CPU/Wait/IO
- Script to Find Most Active Session in Oracle Database for Last One Hour
- SQL Query to Find I/O Intensive SQL and SQLText in Last One Hour
- SQL Query to Find Out Oracle Session Details for a Past Time Period from the History tables
- SQL Query to Find Out Pending Distributed Transaction in Oracle Database
- OCI-How to Generate SSH Keys for OCI instance connectivity
- How to Setup Free Oracle Cloud Infrastructure (OCI) Account
- SQL Query to Get Oracle Database Server CPU, CPU CORE, CPU Sockets and Physical Memory
- RMAN / SQL query to Get Oracle Database Incarnation Details
- SQL Query to Get Oracle DB TIMEZONE details
- How to Check, Disable and Enable Recyclebin in Oracle Database
- SQL Query to Get Oracle Blocking Sessions
- SQL Script to Check the Open Cursors in the Oracle Database
- SQL Script to Find out Total SGA and Current SGA Utilization
- SQL Script to Check the User wise Count in Oracle database
- Script to Kill My Own SQLPLUS Session
- How to Check When was the Table Insert, Update, Delete Done on Oracle Tables or Partitions
- SQL Query to Check Last Modified Time for an Oracle Object
- How Check Hardware type In Linux / Unix
- ORA-01103: database name 'TEST' in control file is not 'CDB'
- DBNEWID – NID Utility – Change DBNAME and DBID
- Flush SQLID or SQL Statement, Object from Shared Pool - DBMS_SHARED_POOL.PURGE
- How to Delete Table, Index, Schema Statistics?
- DataPump EXPDP Estimate [ BLOCKS | STATISTICS ]Option
- How to Check User Quota on Oracle Tablespace - DBA_TS_QUOTAS
- DataPump Expdp KEEP_MASTER Option
- Oracle 12c 18c 19c: How to find out the Listener.log file location?
- DataPump Expdp ORA-39071: Value for EXCLUDE is badly formed
- Datapump COMPRESSION_ALGORITHM Option
- DataPump Expdp ABORT_STEP Option
- Oracle CDB PDB: ORA-65096: invalid common user or role name; Create user Command failed
- SQL Script to Find out Current Running Active, Inactive Sessions Connected to the Database
- How to Remove / Delete / Drop a Machine from Oracle VM Virtual Box?
- iPhone - How to Call Non-emergency Number from Locked iPhone Without Knowing Password?
- WARNING: Your password has expired. Password change required but no TTY available.
- How to Enable or Disable the Supplemental Logging in Oracle Database
- Startup command fails with ORA-27102: out of memory, Linux-x86_64 Error: 28: No space left on device
- Oracle relink all command failed with ld: 0706-006 Cannot find or open library file: -l java
- Expdp failed with ORA-39047 ORA-39047: Jobs of type TRANSPORTABLE cannot use multiple execution streams
- How to Copy and Multiplex Oracle OCR into Different Disk Group
- Check/Find Location and Status of Oracle OCR and VOTEDISK
- PROC-50 PROT-30: The Oracle Cluster Registry location to be added is not usable
- Settings to Run SQLPLUS from Other or Non-Oracle User
- Steps to Remove / Deinstall Oracle OEM, OMS from Unix Server
- Oracle Sql Query to Find Out Number Of Weeks Between Two Dates
- Database Connection Using SQLPLUS Without tnsnames.ora from Command Line
- digitizeindia.gov.in: What is the Reward Point Conversion rate / Value in Rupee or Paise?
- digitizeindia.gov.in: Snippets have exhausted. Please try again later
- 2 Ways to Run / Execute OS (Unix, Linux, Windows) Commands, Shell Script from SQLPLUS or SQL prompt
- Fix Oracleasm Deletedisk Command Failed with Unable to Clear Disk “Disk Name”
- Oracle 12c Data Redaction (Full, Partial, Random, Regular Expression) Implementation Examples
- ERROR: OMS_HOST cannot be null. Pass OMS_HOST value either as command-line arguments or in response file
- 3 Ways to Invoke / Open Vi Editor by ed Command in SQLPLUS
- Fix terminating the instance due to error 27625; Instance terminated by RBAL, pid = ; summary=[abnormal instance termination]
- Silent Installation of OEM 12c agent: manually using emcli, scripts and response file
- onewaycopyAction : Source File dropdb.pl" does not exists or is not readable; Cannot copy file from 'dropdb.pl' to '/u01/app/12.1.0/grid/crs/install/dropdb.pl'
- Steps to Recover Database from RMAN Backup TAG
- Steps to Enable fast_start failover (automatic) in Data Guard(DG) Broker
- Steps to Setup Data Guard Broker (DG BROKER) in Oracle 12c RAC Database with ASM
- Steps to Setup / Configure Data Guard and Broker on Oracle 12c RAC ASM Multi Node Database
- ORA-16693: requirements not met for enabling fast-start failover
- RMAN Restore Failed RMAN-06100: no channel to restore a backup or copy of datafile n
- Fix OEM emctl Error: Backend WLS or EM application seems to be down
- Fix ORA-15045 ORA-15120 ORA-27090: Unable to reserve kernel resources for as
- How to Install Wireshark in RedHat Linux
- Fix (wireshark:29484): Pango-WARNING **: failed to choose a font, expect ugly output. engine-type='PangoRenderFc', script='latin'
- Fix DGMGRL Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
- Golden Gate ggsci start manager: ERROR: Parameter file mgr.prm does not exist.
- Unable to Bring Up RAC Clusterware: ORA-15081: failed to submit an I/O operation to a disk, ORA-27072: File I/O error
- IE on Windows 10 Error: SSL Network Extender Service is down and could not be started. Consider rebooting the computer. (#323)
- Fix ORA-01504: database name 'RESTRICT' does not match parameter db_name 'DBNAME'
- 12c RAC Data Guard DGMGRL: show configuration failed with Error: ORA-01017: invalid username/password
- Oracle Installation OUI Warning “Package: nfs-utils-1.2.3-15”
- OEM 12c Cloud Control - Add Host, Target, Cluster, ASM Instance, Database Manually
- Fix Oracle UI Returns Error: PRVF-0002 : Could not retrieve local node name
- DGMGRL Edit Configuration and Switch Over fails with Error: ORA-16627
- CRS-4638 CRS-4535 CRS-4530 CRS-4534 CRS-2674: Start of 'ora.cssd' on 'Node2' failed
- GoldenGate ggsci command failed with error while loading shared libraries: libnnz12.so, libons.so, libclntsh.so.12.1, libclntshcore.so.12.1
- GoldenGate Start Extract Command Failed with OGG-00868 ORA-01291: missing logfile
- GoldenGate Start Extract Pump Failing / Abending with OGG-01224 TCP/IP error 111 (Connection refused)
- GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 28,365
- GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 26,665
- GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 24,034
- How Stop / Start Multiple Database Instances Under One Oracle Home in Single srvctl Command?
- Perl script (rootcrs.pl) execution failed: Can't locate Env.pm in @INC (@INC contains:
- Fix IMPDP ORA-39006 ORA-39213
- Oracle SQL Query to Find Only the Directory Names of the Datafiles
- Fix Opatch: Missing command :fuser Prerequisite check "CheckSystemCommandAvailable" failed.
- Oracle 12c: How to Create ASM Cluster file System (ACFS) Using ASM Configuration Assistant (ASMCA)
- Fix: /usr/bin/ld: warning: libstdc++.so.5, needed by libsc_ca.so, not found
- Fix ORA-12712: new character set must be a superset of old character set
- Where You Can Find the Oracle 11g 12c DBCA Installation / Trace Logs
- DBMS_MACADM Package to Disable / Enable Database Vault in Oracle 12c
- Fix: ORA-15081: failed to submit an I/O operation to a disk; Unmounting ASMlib driver filesystem: failed
- ORA-01105 ORA-19808: Database Instance Startup Failed with ORA-01105: mount is incompatible with mounts by other instances
- [INS-40719] IP address configured for Single Client Access Name (SCAN): is already assigned to another system
- Install Oracle GoldenGate 12.2.0.1.1 on Linux – Step by Step Instructions
- How to Remove / Deinstall Oracle Grid Infrastructure / Clusterware Software from RAC Nodes on Linux
- How to Remove / Deinstall Oracle Database Software from RAC Nodes on Linux?
- wget Command: Download Oracle Software from www.Oracle.com
- How to Install and Check Required rpms for Oracle 12c on Linux 7
- ARCHIVE_LAG_TARGET: Why So Many Archive Log Getting Generated Even Without Any Transaction in Oracle Database
- How to Check Oracle 11g 12c Database Wallet is Open or Not? v$encryption_wallet
- Oracle: SQL Query to Find out Index Name, Column Name for Table
- How to Backup and Recovery Using Backup as Oracle RMAN Image Copy
- Query to Find Out The Total File Size And Data Occupied Size Of Oracle Database
- Sql Query to Get Hostname, IP Address and Terminal from Oracle Database
- Stop / Disable automatic ads web page opening in Chrome / IE browsers (giraffetraffic.com , go.oclasrv.com)
- How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?
- Oracle SQL Script to Get Daily Thread Wise Archive Log Generation Report
- Kerala PSC Thulasi: New Declaration is required. You are not eligible to apply for this post
- How to Get SQLPLUS Query Output to a Shell Script Variable
- Linux Screen Command: re Attach an Already Attached Session
- Fix for Chrome: These Settings Are Enforced By Your Administrator. A 100% working solution
- Fix ORA-15505: cannot start workload capture because instance 1 encountered errors
- Unix Linux Script to Attach and Embed the HTML File in Mail Body
- TNSPING and SQLPlus works but not Able to connect SQL Developer
- Enable Auto Task Maintenance Jobs in Oracle Scheduler Window Manually
- Stop / Drop Scheduled / Running jobs in Oracle
- RMAN-08591: WARNING: invalid archived log deletion policy
- Insert to Oracle View failed with ORA-01779: cannot modify a column which maps to a non key-preserved table
- Where/How to Check Alert Log File in Oracle 12c?
- Stop/Enable/Disable Oracle Auto Task Jobs Using SQL – Space advisor, Optimiser stats collection, SQL tuning advisor
- Oracle 12c Data Pump: EXPDP IMPDP VIEWS_AS_TABLES Option
- How to Check/Verify the ADDM is enabled in Oracle Database?
- How to Sync Applications in iPhone with iTunes 12 (12.1.1.4)
- How to Check Bank Account, Aadhaar Linking Status with HP Gas Online
- How to Remove Duplicate lines from Unix vi Editor file
- How to Copy Only Contacts, Notes and Messages from iTunes after iPhone Factory Restore?
- Fix: iPhone Old Messages are not Indexing in the Spotlight search after the iOS 7 Upgrade
- Database in READ WRITE Mode; desc dba_ gives error ;ORA-04043
- Solve ORA-39170: Schema expression 'OPS' does not correspond to any schemas
- How to Find out / Check SGA and PGA size of Oracle Database?
- Find out Database Growth Month by Month Using V$datafile - Creation_time
- How to Check the Required Data is Present in Flashback Database or not for Recovery?
- How to Enable/Configure and Disable Flashback (On/Off) Feature in Oracle
- Listener Not Starting: IBM/AIX RISC System/6000 Error: 1: Not owner TNS-12555, TNS-12560, TNS-00525
- Fix ORA-30052: invalid lower limit snapshot expression
- Oracle Script to Create or Drop Series of Users or Schemas
- Find out New or Updated Rows from an Oracle Table without having Date Column
- Method to Create New Column in Oracle Table with Combination Other Columns
- Impdp Expdp Failed with ORA-31626, ORA-31633, ORA-06512, ORA-01031
- Use of Expdp Impdp nologfile=y
- Method to Track Oracle Schema User Password and Modification History; Find out Current, New Password
- Sql Query to Find and Reclaim the Fragmented Space in Oracle Table
- Example for Table Reorg and Reclaim the Fragmented Space Using Shrink Space Command
- Example for Table Reorg and Reclaim the Fragmented Space Using Table Movement
- Difference Between Oracle Table Shrink Space, Space Compact, Space Cascade - with Example
- How to Shrink a Table in Oracle Database - With Example
- Recursive Function, Procedure, PLSQL in Oracle
- DGMGRL ORA-16600: not connected to target standby database for failover
- DGMGRL Error: ORA-16647: could not start more than one observer
- DGMGRL Error: ORA-16820: fast-start failover observer is no longer observing this database
- ORA-06512 ORA-06503: PL/SQL: Function returned without value
- Oracle Session Disable Commit in Procedure
- Oracle Query to find out the SQL Text Using the Unix Process ID SPID, SID and for Long Running Sessions
- Sequence Default Cache value 20; ORA-04013: number to CACHE must be less than one cycle
- Difference Between Oracle Join and Union
- Change / Modify / update AdSense Publisher Bank Account for EFT Wire Transfer
- IMPDP Import Only the Rows Does not exist in the Target Table
- EXPDP Filesize : Split or Slice the Dump file into Multiple / Different Directories and File Systems
- Oracle Sequence Cycle vs Nocycle Difference and Comparison
- Show Error Returns with No errors: How to find out PLSQL Compilation Errors?
- How to find out the Size of the Oracle Database (Any Versions 10g, 11g)
- Oracle pfile vs spfile: Difference and Comparison
- Oracle SQL, Function for finding out Age from DOB
- Create or Alter User failed: ORA-00600: internal error code, arguments: [kzsviver:4]
- TRACEFILE_IDENTIFIER Parameter Oracle 11g
- Putty Configuration Error: There is no disk in the drive. Please insert a disk into drive
- Data Pump Expdp ESTIMATE_ONLY Parameter
- Oracle SQL to Check the Database / Instance Name to Which the Current Session Is Connected using a Non DBA user
- Data Pump Expdp Impdp Metrics=Y Undocumented Parameter
- Invoke Data Pump EXPDP IMPDP export / import Using SQL Developer
- Data Pump Impdp show=y Replaced with SQLFILE Option
- Create File or Modify the Existing UNIX/LINUX File With Old / New Timestamp
- Unix Shell Script to Find out Files Created within x Hours Without Using mmin / cmin for Solaris
- Replace SQL Null Values with SQLPLUS Set Null Command
- Create a Case Sensitive Table in Oracle / Table Name in Lower Case
- How to Check the Number of Concurrent Users in the Oracle Database Dynamically?
- Fix ORA-01927: cannot REVOKE privileges you did not grant
- Compress/zip Sqlplus Spool Output Automatically with Sql Execution Using UNIX Pipe
- SQLPLUS: Create Spool File with DB Schema Name and Current Time and Date/Sysdate
- Rename Oracle 9i, 10g, 11g Datafile with Blank Space/White Space/Special/New line Characters
- How to Append Command Outputs To Oracle SQLPLUS Spool File
- Fix ORA-14400: inserted partition key does not map to any partition
- How to Check Oracle 9i, 10g, 11g Scheduler Jobs Status
- How to Run Expdp Impdp Jobs in Background
- Without WWW Blogger Blogspot Domain is not Working- “Not Found 404”
- How to Fix ORA-20005: object statistics are locked (stattype = ALL)
- Pay BESCOM Electricity Bill Online for Sarjapur Location
- How Can I Get vi Editor Commands History
- Oracle Cast Function: ORA-01438: value larger than specified precision allowed for this column
- Opatch Failed error code 73: OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables"
- Data Pump Expdp Impdp Exclude Include Table Partitions – Table_data option
- Reason for ORA-00439: feature not enabled: Partitioning
- Create Jpg, png, PDF Oracle Database Schema ER / Table Relationship Diagram Using Data Modeler
- Fill Maadi Win Aagi: Win Prizes from IOC Fuel Outlets
- ORA-01732: data manipulation operation not legal on this view
- Fix ORA-08189: cannot flashback the table because row movement is not enabled
- Oracle Create View Syntax: 9 Different Examples
- Oracle Create Table Syntax: 19 Different Examples
- NoMachine Tool: Better Remote Desktop Connectivity across Different OS platforms
- Oracle NO_INDEX hint: Syntax, Purpose and Example
- How to Bypass DROP ANY TABLE Privilege for Truncate Table Command
- How to Check AWR Snapshot Setting using SQL Queries?
- Expdp Export Failed: ORA-00439: feature not enabled: Dump File Data Compression
- Expdp / Impdp Tablespace Parameter Benefits and Examples
- How to Perform a Date Test Case with Old or Upcoming Sysdate in Oracle? - FIXED_DATE Parameter
- Oracle Delete and Update Commands Executes With Set Autotrace Traceonly Explain
- SQL Developer, Data Modeler Failed: Unable to Launch the Java Virtual Machine Located at Path:
- How to Check Which User is Connected to Current Oracle Session? 3 different methods
- How to Modify / Set SQLPlus Prompt With Connected Username and SID?
- How to Avoid / Stop /Restrict the Dropping of User Schema by Mistake from Oracle Database?
- How to Exclude MLOG$ Materialized View Log Tables from the Data Pump IMPDP
- Oracle dbms_utility.get_dependency to Get Dependent Objects or Dependencies of a Table
- How to Kill or Resume [1]+ Stopped Unix Jobs
- How to Add or Insert Current Log Time and Date to a Notepad File Or Whenever You Open the file by Default
- Oracle 12c Data Pump EXPDP IMPDP Logtime Option Parameter
- How to Identify Connected Database Instance is Primary or Standby?
- SQL*Loader PARFILE Parameter
- SQL*Loader DISCARDMAX Parameter
- How to Remove / Hide Post Counter from Blogger Archive Widget in New Interface
- How to Hide / Remove ‘Subscribe to: Post Comments (Atom)‘ From the New Blogger Interface 2013
- Shell Script to Execute Oracle Sql Script in Crontab for a Specified SID
- How to Automate / Schedule Oracle Gather Table Statistics Job through Crontab?
- SQL Loader bad file vs Discard File: Difference and Examples
- Oracle SQL Loader Bad file (.bad) Parameter Example
- 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
- Shell Script to Print Only First / Last Words in all Lines of a Text File
- Data Guard / Standby: ORA-01156: recovery or flashback in progress may need access to files
- How to see / Check the Step by Step Execution of a Shell Script for Debugging?
- How to Set / Unset Default Value for Command Line Arguments For a shell script?
- Shell Script to Repeat the Execution of Command / Job Based on Time Interval Periodically
- Data guard / Stand by: What are the Steps to Move Datafiles / Logfiles to Different Location?
- Data Guard / Standby: ORA-01624: log %s needed for crash recovery of instance %s (thread %s)
- Fix DGMGRL: Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
- How to Find out / Identify the list of Schema / Users Available Inside a expdp data pump .dmp dumpfile
- How to Identify / Check / Find out Oracle .dmp dumpfile is Taken Using Exp / Expdp – Data Pump
- Oracle 11gR2: Truncate Drop Storage Vs Drop All Storage Clauses
- How to Pay Kerala Electricity Bill Online? Introduced New System from 23-April-2013
- Unable Access Password Protected Spread Sheet / Document Google Drive On iPhone
- By Pass the User Password Using Grant Connect Through clause
- ORA-28150: proxy not authorized to connect as client
- How to Append Extra New Records to Table Using Oracle SQL loader?
- What are the Advantages / Benefits / Features of Oracle SQL loader?
- What is CLRExtProc, PLSExtProc and extproc in Listener.ora? Why actual database SID is not mentioned in listener.ora by default?
- CAN FLASH to 111 Method to Disable / Stop / Turn off / Deactivate unwanted Vodafone Flash Messages
- How to install an application from iTunes to iPhone
- How to Hide / Disable / Remove DISQUS Discovery “ALSO ON” YOUR SITE feature?
- F4 Key to Repeat Last or Previous Action / Task in Microsoft Excel or Word 2007 and 2010?
- How to Hide / Disable / Enable DISQUS AROUND THE WEB Discovery ads?
- Oracle Upgrade Catupgrd.sql failed: with SELECT TO_NUMBER('MUST_BE_11_2_0_3') FROM v$instance
- Steps to Configure Oracle 11g 10g RMAN Catalog in Same / Different Database
- IMPDP EXPDP ENCRYPTION_PASSWORD Parameter ORA-39173: Encrypted data has been stored unencrypted in dump file set
- Adsense CPC Fluctuation / CPC Drop Reasons, Key Factors for CPC Improvement
- ORA-00214 control file flash_recovery_area version %s inconsistent with file version %s
- Fix ORA-38814: ALTER SESSION SET EDITION must be first statement of transaction
- How to Delete / Drop All the Tables in One / Multiple Oracle 10g 11g Schema
- Data Pump impdp expdp Full, Schema, Table Level Export / Import Syntax with Examples
- Error in invoking target ‘mkldflags ntcontab.o nnfgt.o’ of makefile net_client.mk: Oracle installation failed
- file not found dbhome_1\oc4j\j2ee\oc4j_applications\applications\em.ear – Oracle Installation failed
- Oracle 11gR2 Installation Prerequisite Checks Failed on Windows XP
- OUI-10094:Problem in saving inventory. Current access level does not allow writing to the inventory
- OS error in starting service OracleMTSRecoveryService: Oracle 11gR2 Installation Fails
- Google Page Rank (PR) Latest Recent Update Happened on 04 Feb 2013
- Simple Page Navigator for Home and Archive Blogger Pages with Numbers and Customization Tricks
- Use dbms_xplan.display_awr to Pull Full SQL and Execution Plan for a Query in AWR
- What is Oracle BBED Tool? How to make it Available in Oracle 11g?
- How to Recover / Restore / Recreate Dropped Dual Table in Oracle? ORA-01775: looping chain of synonyms
- Difference between BIGFILE and SMALLFILE tablespace, Advantages. How to Create and Resize Bigfile Tablespace?
- Select from System Package DBMS_METADATA Failed: ORA-25153: Temporary Tablespace is Empty, ORA-06512
- Insert, Delete, Truncate Operations with Oracle Dual Table. Just Not Fun
- How to Query / Generate Multiple Rows from Oracle DUAL Table?
- Siebel Database Configuration Failed: C102: The Username / Password Combination.00000: cannot be validated at this
- How to Check What is Getting / Being Audited in Oracle Database?
- Will Oracle Unique Key Constraint Allow / Accept more than One NULL Value?
- crontab Commands Fails in Linux: You (%s) are not allowed to use this program (crontab)
- STOP / Disable Oracle 11g ADDM, AWR using control_management_pack_access Parameter
- How to Change / Move Oracle Inventory Location to another Directory?
- dbms_stats.gather_table_stats : ORA-00600: internal error code, arguments: [smboPut:fixedlen2]
- Oracle SQL Query to Print / Display Calendar Using 11gR2 LISTAGG Function
- How to Disable / Escape / Avoid / Stop & and && Variable Substitutions in Oracle SQL Plus
- Procedure to Apply and get OCP Certificate and Logo who Completed Exams Hands on Training
- Data Pump Impdp TRANSFORM option SEGMENT_ATTRIBUTES, STORAGE, OID and PCTSPACE examples
- How to Prepare awk Data Report? Example
- How to Check Which Child Directory is consuming More Space in Unix/Linux?
- Data Pump impdp remap_table Option to Change the Table Name During Import
- Using vi, awk, sed - erase / remove / cut Few First , Last Characters in all lines of Linux file
- Count & Remove Repeating / Duplicate lines in Linux/Unix file
- vi, awk, sed - Substitute / Replace Few First , Last Characters in all lines of Linux file
- Implement Delay or Sleep in Oracle PL SQL Scripts Using DBMS_LOCK.SLEEP?
- How to Copy File without Changing Last Modified Date, Time stamp and ownership in Linux / Unix?
- cp , ln Commands to Create soft Links for all Files in Linux / Unix Directory
- How to Copy Only New / Modified / Changed Files in Unix / Linux?
- Truncate failed ORA-24005: Inappropriate utilities used to perform DDL on AQ table
- What is Data Pump Expdp SOURCE_EDITION and Impdp TARGET_EDITION Options? Examples
- How to Create Different Editions or Versions for Oracle Objects? Its Advantages
- Data Pump IMPDP failed: ORA-31655: no data or metadata objects selected for job and ORA-39154
- Oracle 11gR2 Impdp DATA_OPTIONS SKIP_CONSTRAINT_ERRORS: How to Skip Constraint Errors during Import?
- RMAN Configure Backup Optimization ON / OFF : Features & Example
- Fix ORA-15097: cannot SHUTDOWN ASM instance with connected client (process %s)
- Fix Oracle 11g Database Block Corruption? - Recovery Using RMAN Backup ORA-01578: ORACLE data block corrupted
- Add or Insert a Heading Extra Line after Every nth Line of File in Unix / Linux
- How to Open and Save UNIX / Linux man Pages to vi Editor File?
- How to Create a Fixed Huge Size File in Unix / Linux Using dd Command?
- Why Oracle DBA_TEMP_FILES view Bytes Column is NULL: How to Drop, Shrink Offline / Online Temp File
- Oracle 11g Database Startup Failed: /dev/shm and ORA-00845: MEMORY_TARGET not supported on this system
- Datapump IMPDP Partition_Options = MERGE , DEPARTITION Examples
- Duplicate Command Failed: RMAN-05001: auxiliary filename %s conflicts with a file used by the target database
- OC4J Connection Pool Error Message: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
- Fix ORA-02032: clustered tables cannot be used before the cluster index is built
- Truncate Failed: ORA-03292: Table to be truncated is part of a cluster
- Shell Script to Run RMAN Backup in Background with nohup
- Move Subpartition for an Interval Partitioned Table Failed: ORA-00600 [kkpod nextFrag]
- Fix IMP-00013: only a DBA can import a file exported by another DBA
- Fix IMP-00058: ORACLE error 1950 encountered
- Blogger Blogspot Page views Reset to Zero Today - Resolved
- Rail Radar: How to Live Locate Indian Railway Trains in Google Map!!
- Index Rebuild Online Failed Oracle 11gR2: ORA-01450: maximum key length (3215) exceeded
- Fix Oracle 11g Client sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
- How to Find out / Check / Set Values for Hidden Underscore _ Parameters in Oracle?
- Validate Exception Queue: ORA-24017: cannot enable enqueue on QUEUE
- Data Pump EXPDP Error: ORA-39181: Only partial table data may be exported due to fine grain access control on
- 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
- Oracle SQL Select Statement / Function to get Server Memory, CPU and Processor details
- ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 2: No such file or directory
- dbms_lob.write Failed with ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
- ORA-06502: PL/SQL: numeric or value error: raw variable length too long: Convert Varchar2 to Blob with utl_raw.cast_to_raw
- Convert Oracle Varchar2 column to Blob data type Using utl_raw.cast_to_raw – Example
- Fix ORA-19870 ORA-19863: device block size 4186112 is larger than max allowed: 1048576
- HISTTIMEFORMAT: How to See the Linux commands History with Date and Time?
- Siebel Error SBL-ODC-00105 ORA- 24345 A Truncation or null fetch error occurred
- Oracle EM Alert: Critical:DBNAME - There have been n failed login attempts in the last x minutes: Identify the LOGIN failure with 1017 returncode
- How to Perform Multiple Comparisons in Oracle SQL Query Using Select .. Case .. When .. Else
- ORA-04031: unable to allocate 2048024 bytes of shared memory: 11 g RAC Fix error
- How to Fix PLS-00201: identifier 'DBMS_AQ' must be declared
- How to Renew the Domain Registered From Blogger Settings – Domain Auto Renewal via Google Apps
- 11g Deferred Segment: ORA-01950: no privileges on tablespace
- Fix ORA-14402: updating partition key column would cause a partition change
- How to Configure Tablespace / Monitoring Alert Emails in Oracle 11g OEM Rules
- How to Avoid / Remove Adsense Ads from Homepage / Archive Page in Blog
- Steps for RMAN Recovery from Old Incarnation without Catalog
- ORA-20021: database not set: Select From RC_BACKUP_FILES Table failed
- How to Use ORADEBUG to Find out Trace file name
- How to Use ORADEBUG CURRENT_SQL to See Other Session SQL
- FireFox: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser
- Internet Explorer: Uninstall / Disable / Remove Yahoo Axis Search Bar from IE Browser
- Google Chrome: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser
- Traffic after Registering Custom Domain for Blogger Blogspot - My Experience
- Work Around for ORA-00600: [kkpo_rcinfo_defstg:objnotfound], [75312]
- Find out Maximum, Current Limit of Oracle Resources (Session, Process, Lock) using v$resource_limit
- Purpose of ORAENV_ASK=NO / YES variable in Oracle
- Data Pump EXPDP IMPDP content=METADATA_ONLY to Extract the Skeleton of the Oracle Database
- How to Check / Find out the Privileges and Roles for My Own Session Oracle
- ORA-00059: maximum number of DB_FILES exceeded - Fix / Resolve Oracle Add Datafile Error
- ORA-28001: the password has expired - Permanent Fix for NOEXPIRY for Oracle User
- Data pump IMPDP SKIP_UNUSABLE_INDEXES=Y/N Parameter Option Example
- Example on Data Pump EXPDP IMPDP Parfile Option
- How to Schedule / Execute / Run an Oracle Procedure through DBMS_JOB?
- Check Who is Accessing / Locking / Blocking the Oracle Session / Table
- How to Run / Schedule a PLSQL Procedure In Shell Script and Crontab?
- How to Keep / Pin / Check PLSQL Objects in Buffer Cache / Memory Using DBMS_SHARED_POOL.KEEP
- Find / Check Hot/Frequently Accessed Objects in Oracle 10g 11g Database Using v$db_object_cache
- How to Set / Fix / Limit the Oracle 10g 11g Trace File Size
- Script to Generate and Spool DDL / SQL statements for Tablespaces in Oracle 10g 11g Database
- Syntax to Find / Check / Change / Set Default Permanent Tablespace for Oracle 10g, 11g Database
- Different methods to find out NLS Parameters from Oracle Database
- How to find / Set NLS_LANG in Solaris AIX Unix and Windows for Oracle?
- Syntax to Find / Check / Change / Set Default Temporary Tablespace for Oracle 10g, 11g Database
- Oracle 11g User Account Status LOCKED(TIMED) with FAILED_LOGIN_ATTEMPTS, PASSWORD_LOCK_TIME Parameters
- Data Pump EXPDP FLASHBACK_SCN Parameter
- IMPDP FLASHBACK_SCN, FLASHBACK_TIME Shows in Parameter Help – Is it a bug?
- Troubleshoot Fix error IMP-00038: Could not convert to environment character set's handle
- Troubleshoot Fix IMP-00010 not a valid export file header failed verification
- Why Adsense Ad Slots are Blank / Empty – Main Reasons
- Data Pump EXPDP IMPDP Status Parameter for Feedback
- No More New PayPal Donate Buttons for Indian Bloggers / Users
- Data Pump IMPDP REMAP_TABLESPACE Parameter Syntax and Examples
- Data Pump IMPDP REMAP_SCHEMA Parameter Syntax and Examples
- SQL Syntax to Add Offset Hour, Minute, Year, Day, Month to Oracle Timestamp Values Examples
- Difference between LOG_ARCHIVE_DEST_1 LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST
- Troubleshoot Fix ORA-16018 ORA-16019 ORA-02097 Oracle Archival Errors
- Add Oracle Constraints – Primary, Foreign, Unique, Check, Null to Existing Table
- How to Add / Install RSS Feedburner Reader Counter to Blogger?
- Oracle 11gR2 LISTAGG Analytical Function – Concatenate / Select Multiple Rows of a Table to Single
- How to Check / Find the Oracle Table Depended Objects?
- Reasons for PL/SQL Code Block Failure with ORA-01001: invalid cursor
- Select Failed with ORA-00980: synonym translation is no longer valid
- Create Synonym Failed with ORA-01471: cannot create a synonym with same name as object
- Oracle SQL Query to Find out Nth Largest, Highest, Lowest, Smallest Values
- Troubleshoot Fix unrecoverable error ORA-29701 raised in ASM I/O path; terminating process 17946
- Interesting Features of Oracle TO_DATE and TRUNC Functions
- Oracle SQL Query to Find out Cumulative SUM and Duplicate Rows of a Table Records
- How to Extract / Get Script for DBA_, V$ Oracle Data Dictionary Views?
- Will IGNORE=Y Option Work with Data Pump IMPDP
- Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE
- Oracle DBMS_RANDOM Package to Generate Random Numbers, Strings
- Generate Random Date between Dates or Period Using Julian Date and DBMS_RANDOM package
- Oracle V$ vs RAC GV$ Dynamic Performance Views – Difference and Features
- Trick to HIDE / Mask Oracle User Password in Alter User Command?
- Oracle 11gR2 NTILE Analytic Function Usage Syntax
- Index Rebuild Failed With ORA-14456: cannot rebuild index on a temporary table
- Oracle 11gR2 NTH_VALUE Function Usage Syntax
- Rename Command fails with ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
- Script to Find out SQL Text from Oracle 11g, 10g RAC Database Using SID, SPID
- Advantage of Caching / Pinning/ Keeping an Oracle Table in Buffer Pool
- Take / Generate Oracle 10g 11g Active Session History Report (ASH) Manually
- Fix ORA-02299: cannot validate (SCOTT.EMP_UK) - duplicate keys found
- Retrieve / Recover / Restore Dropped Table in Oracle 10g 11g Using Flashback Table Feature
- How to Drop Oracle 10g 11g Bin$ / Recycle bin Tables
- Oracle Kill Session Command Fails with ORA-00027: cannot kill current session
- Oracle Create table, Materialized View Command Fails with ORA-01723: zero-length columns are not allowed
- Public Database Link fails with ORA-12154: TNS:could not resolve the connect identifier specified
- Oracle 10g 11g Archivelog Vs Noarchivelog Mode Difference, Advantages, Features
- How to Calculate Income Tax (IT) for New Financial Year 2012-13 after Budget
- How to Remove / Hide / Disable Google Plus One +1 Button from Adsense Image Ads
- 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
- Reasons and Workarounds to Fix ORA-00997: illegal use of LONG datatype
- How to Convert the AIA xref_data Cross Reference table LAST_MODIFIED, LAST_ACCESSED to Date?
- Reasons for ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
- Data Pump vs EXP/IMP: Difference or Comparison Between Data Pump Expdp/impdp and Conventional EXP/IMP
- Execute Immediate Command Fails with DBA role: ORA-01031: insufficient privileges
- Fix ORA-10636: ROW MOVEMENT is not enabled Table Shrink Command Failed
- ORA-10662: Segment has long columns, Table Shrink Command Failed: Workaround
- Fix Data Pump EXPDP Error ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
- Database Recovery from Corrupted, Missing Redo, Archive Log Files Using _ALLOW_RESETLOGS_CORRUPTION, _CORRUPTED_ROLLBACK_SEGMENTS, _minimum_giga_scn and _allow_error_simulation
- ORA-01548: active rollback segment, Find out Oracle 10g 11g Active Undo Segments from system datafile
- How to Share / Add / Embed Youtube Video to Blogger Posts?
- Google Animated Music Doodle on Valentine’s Day 2012
- Purpose of ADR_BASE_Listener & DIAG_ADR_ENABLED_listener : Oracle 11gR1 Listener ADR Parameter
- Unique Index Creation Failed: ORA-12801: error signaled in parallel query server P018, instance
- Oracle 11g LMon RAC Background Process Functions
- Terminate/Kill/Stop Data Pump EXPDP IMPDP Executing Jobs
- Oracle SQL Script to Compile All Package, Body in a Schema
- Oracle 10g 11g Data Pump EXPDP Query Parameter option
- Oracle 11g ORA-12916: cannot shrink permanent or dictionary managed tablespace; Oracle Tablespace Shrink Command Failed
- Relation / Difference : O7_DICTIONARY_ACCESSIBILITY = TRUE / FALSE, SELECT ANY DICTIONARY, SELECT CATALOG ROLE and SELECT ANY TABLE
- userenv('ISDBA') : To check the Current Oracle Session has DBA Privilege
- 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?
- Oracle ASM Datafile add / resize failed with ORA-01237 ORA-01110 ORA-17505 ORA-15041: diskgroup "DATA" space exhausted
- How to Refresh / Recalculate Microsoft Excel Column Formula Automatically
- RMAN Duplicate Database Failed with RMAN-06136, ORA-15001: diskgroup "DATA_CEX" does not exist or is not mounted
- Prepare / Generate repetitive SQL Scripts Using Microsoft EXCEL CONCATENATE Function
- Oracle 11G SQL Command Syntax to Check Free Space, Shrink Temporary Tablespace or Tempfile
- Oracle 10g 11g Data Pump EXPDP SAMPLE Parameter Option
- Oracle Data Pump EXPDP IMPDP REMAP_DATA Parameter for Data Transformation with Example
- Oracle 10g 11g RMAN Useful Commands
- Fix RMAN-04014 ORA-00439: feature not enabled
- Fix RMAN Duplicate Database Failed with ORA-20 Connecting to ASM Instance
- SQLPLUS Connect, Startup Fails with ORA-09925: Unable to create audit trail file SVR4 Error: 13
- Fix RMAN-04014 ORA-07446: sdnfy: bad value '…/bdump' '…/udump'
- Expire Oracle User Password in Few Minutes Using Profile Resouces PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME
- ORA-28011: the account will expire soon; change your password now
- How to Disconnect or Expire the Idle Oracle 10g 11g Sesssions Automatically Using Profile IDLE_TIME Resouce
- DBMS_SCHEDULER. Create_job Fails with ORA-06512 ORA-27486: insufficient privileges
- How to Add / Install Syntax Highlighter for Scripts in Blogger Post – SQL, Java, Python, HTML etc
- Fix Oracle 10g 11g Data Pump IMPDP Failed withORA-39002 ORA-06512 ORA-39070 ORA-29283: invalid file operation
- What are the Considerations for EXADATA Smart Scan Cell Offloading?
- One More Interactive Music Doodle from Google: Happy Holidays 2011
- EXADATA Smart Scan - cell_offload_plan_display = NEVER / AUTO /ALWAYS Parameter
- Fix Duplicate Database failing RMAN-06136: ORA-01618: redo thread is not enabled - cannot mount
- opt_param ( 'cell_offload_processing' , ’TRUE/FALSE’ ) Hint to Enable EXADATA Smart Scan Feature: Speed Comparison with Smart Scan
- Floating Facebook Like, Share, Google Plus One +1 Button Gadget HTML Code For Blogger
- Google Language Translator Gadget HTML Code: With Small Beautiful Flags for Blogger
- Main Reasons for Delay or Not Receiving the Adsense PIN after a Period of Time
- Different Methods to Print Single Quote (') in AWK programming
- Fix RMAN-03009 ORA-00245 RMAN-08132 control file backup operation failed
- Tested Tips to Increase or Improve Adsesnse CTR
- Oracle 11g 10g Database SQL Script to Find Out Active Sessions Waits
- Fix DB Link Error ORA-02085: database link connects to
- Oracle 10g 11g RAC ASM RMAN Database Cloning to Different Server with Different File System
- How to Rename Oracle Database Using NID command Line Utility
- Oracle 10g 11G RAC Database Control File Creation Failed with ORA-01503, ORA-12720: operation requires database is in EXCLUSIVE mode
- How to Change Oracle 11g 10g RAC database to Noarchivelog mode?
- How to See the Oracle 10g 11g Bind Variable Values Using v$sql_bind_capture
- Benefits of Registering Own Custom Domains for Your Blog on Blogger or WordPress
- Reset the Password for an Oracle Expired Login or Username to Old or Previous Value
- RMAN Reset Incarnation Failed: ORA-19910: can not change recovery target incarnation in control file
- How to Restore Oracle RMAN Backup from Previous or Old Incarnation
- How to Force Oracle RMAN to Delete All Archive log files
- Oracle RAC Startup failed ORA-01102: cannot mount database in EXCLUSIVE mode
- Database startup failing ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used,
- RMAN-06059 ORA-19625 backup archivelog all delete input
- FIX RMAN-11001 ORA-01547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"
- Fix RMAN-08138: WARNING: archived log not deleted - must create more backups
- Fix RMAN-04005 ORA-01031: insufficient privileges RMAN-00554 in Oracle 10g 11g RAC
- Fix RMAN-20242: Specification Does Not Match Any Archive Log
- Exadata Hybrid Columnar Compression – HCC : Comparison between Compress for Query High and Archive High
- Transfer Oracle ASM binary Files One File System to another File System Using DBMS_FILE_TRANSFER
- HTML Code to Place Adsense Ads Side by Side, Left, Right, Center Aligned on Blogger Posts
- How to Recover the Oracle 10g 11g Database from RMAN Cold Backup
- Fix ORA-09817: Write to audit file failed. SVR4 Error: 28: No space left on device
- New Latest Method to Apply Ration Card Online Karnataka – Bangalore 19-Nov-11
- Oracle 11gR2: Generate Number Series Using Select Command with array(x) as clause? UNDEF Command to Reset && variable
- Fix RMAN-06004 RMAN-20001: target database not found in recovery catalog
- Add Datafile, Create tablespace to Oracle database runing on ASM or with Oracle-managed files? Fix ORA-01276
- How to Drop Datafile from Tablespace on Oracle 8i, 9i, 10g, 11g Database?
- Oracle 11g 10g RMAN Duplicate Database Command Using TAG: How to Clone a Database in same server / node
- 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]
- Troubleshoot & Fix RMAN Duplicate database failed with ORA-12720 RMAN-06136
- 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 ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
- Change the RMAN Backup TAG Retention Policy Using Change Backup .. Keep Command
- Oracle 10g 11g Syntax for Lock and Unlock a User Schema Account
- Oracle 10g 11g Shared Database – DB Link – Features, Advantages and Disadvantages
- How to enable voice call in Microsoft Office Communicator 2007 R2 Windows 7 and XP
- Oracle int vs number datatypes difference and features
- How to Rename Tablespaces to a New name in Oracle 9i 10g 11g ?
- Oracle SQL Script to Find Out Active Sessions Details
- Easy Methods to Find Out Oracle 9i 10g 11g DBID
- Different Methods to Find Out Oracle Version From the Database
- How to Use Drop Database Command in Oracle 11gR2?
- 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 encrypt UNIX (solaris AIX Linux) files using vi editior? Protect your UNIX files with password
- Soft Link Vs Hard Link in Solaris & AIX Unix OS – Difference and Features
- 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 Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database
- Get Timestamp from SCN in Oracle 10g 11g? Convert SCN to Timestamp Using scn_to_timestamp and timestamp_to_scn
- How to get Aadhaar UID application enrollment centers information for Maharashtra & Orissa
- How to Rename an Unnamed datafile (UNNAMED00004) to Original Name in Oracle 9i 10g 11g Standby Database?
- How to get Aadhaar UID application enrollment centers information for Uttrakhand, Tripura, Uttar Pradesh, West Bengal?
- How to get Aadhaar UID application enrollment centers information for Tamil Nadu, Puducherry, Rajasthan
- How to get Aadhaar UID application enrollment centers information for Himachal Pradesh, Madhya Pradesh, Haryana?
- How to get Aadhaar UID application enrollment centers information for Goa & Gujarat?
- How to get Aadhaar UID application enrollment centers information for Delhi?
- How to get Aadhaar UID application enrollment centers information for Chandigarh?
- How to get Aadhaar UID application enrollment centers information for Bihar?
- How to get Aadhaar UID application enrollment centers information for Kerala?
- How to Check Aadhaar UID Application Status Online?
- How to get Aadhaar UID Enrollment Centers Information for Karnataka Bangalore– Day Centers and night Centers
- How to get Aadhaar UID enrollment centers information for Maharashtra and Andra Pradesh?
- How to move oracle datafile to different location and rename?
- How to rename and move a oracle system tablespace datafile?
- What is the command to take Oracle Control file backup? Standby Control file, ASCII control file
- Reason and Fix for ORA-25153: Temporary Tablespace is Empty
- What is the significance of Oracle Parameter Global_names=TRUE?
- How to Signup and Install / Add Google Analytics Code to Your WordPress / Blogger Blogs?
- Oracle Views vs Materialized Views – Difference, Advantages, Disadvantages and Features
- How to Check Whether the Oracle Database is Using Pfile or SPfile?
- Oracle Views vs Tables- Advantages, Disadvantages and Features
- Oracle Private vs Public Synonyms – Advantages Difference and Features
- dbms_system.ksdwrt Procedure to Write Custom Messages to Oracle Alert and Trace Files Manually
- Oracle SQLPlus Copy Command Usage Syntax to Copy tables across database
- Usage syntax for Oracle 10g REGEXP_LIKE regular expression function
- Oracle 11g ADRCI – How to Create Package for an Incident or a Problem?
- Oracle 11g ADRCI - Configure and Setup Automatic Diagnostic Repository Using Command Line Interpreter
- Oracle Data Pump expdp impdp Use JOB_NAME Option to Stop_job, Attach, Kill_job and Continue_client interactively
- What is Oracle 11g Problems and Incidents Concept?
- Oracle 11g Automatic Diagnostic Repository – ADR – Features and advantages
- How to Register Your Land, Vehicle, Employment exchange, Company Online?
- How to apply for Government Cards online – PAN, TAN, Ration, Passport, and Electoral
- How to Apply for Government Certificates Online – Birth, Caste, Tribe, Dominical, Driving, Marriage and Death
- Oracle 11g Security SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter
- Delete vs Truncate in Oracle 9i 10g 11g – Difference and advantages
- How to Create Case Sensitive Password File in Oracle 11g?
- Oracle 11g Enable Case Sensitive Passwords For Improved Password Security
- Kochi Metro Railway Stations Route List
- How to Check and Find Out PF Account Balance and Details online? Portal Lauched on 01-07-2011with SMS
- Oracle 11g Password : Relation between user$, DBA_USERS, PASSWORD_VERSIONS, spare4, IDENTIFIED BY VALUES
- Explicit Vs Implicit Commit in Oracle– Difference and When it Occurs?
- How to Check Vehicle Registration Details Online? Goa, Kerala, Delhi
- Oracle 11gR2 SQLPlus SET EXITCOMMIT ON/OFF
- How to hide oracle passwords - sqlldr, sqlplus, exp, imp, expdp, impdp from Unix ps command?
- Export and Create Excel File from Oracle SQL Query Spool Output File
- What is the datatype and precision of Oracle NULL column?
- How to read (command) without enter in Linux bash shell?
- How to check the pending transaction in your oracle session?
- How to create dummy NULL column for a Oracle view using function?
- Script to increment or decrement all sequences in a schema by n=1000 numbers
- Reset/Modify/alter Oracle sequence nextval, currval to new value without dropping
- Find out the income tax (IT) ward/circle for income tax e-filing
- How to check file last modification or change date and time details in Linux?
- Oracle 11g Data Pump expdp compression option to reduce the export dump file
- Features and Advantages of Oracle 11gR2 Deferred segments – Segment Creation on Demand
- Oracle 11g ASM (Automatic Storage Management) Features, advantages and benefits
- Data Pump expdp REUSE_DUMPFILE option: Overwrite existing dumpfile
- Connect to hanging database using sqlplus –prelim option in Oracle 10g, 11g
- How to install/apply/change XML template on new blogger interface
- Easy and quick way to get Google Plus invites. Steps to get Google Plus invitation from my blog
- Troubleshoot fix ORA-28368: cannot auto-create wallet ORA-28353: failed to open wallet
- How to setup Oracle 11g, 10g Transparent Data Encryption - TDE? Advantages, SALT Option
- Troubleshoot and fix TNS-12560 TNS-00583: Valid node checking: unable to parse configuration parameters
- Oracle 11g New Feature: Invisible index advantages for performance tuning
- Oracle INDEX hint : Different usage syntax for performance tuning
- Oracle 11g New Feature : SQLPlus Error Logging Features and advantages
- Oracle 11g New Feature : Advantage of Shrink Temp Tablespace and Tempfile
- CHAR vs VARCHAR Difference, Advantage in Performance Tuning
- Oracle 11g : Read-Only Tables New Feature & advantages
- EMCA dbconsole configuration failed with ORA-20001: SYSMAN already exists
- Data Pump impdp expdp : SQLFILE option to extract DDL and DML from dump file
- Data Pump impdp expdp NETWORK_LINK option : Transfer schema across database using db links without dump file!
- Oracle User Password Reset : Two different methods – SQL*Plus and alter user
- How long needed For Google Adsense Approval for Blogspot? I Got In 2 Months for my new blog! 10 Guaranteed Tips!
- Les Paul Interactive Music Google Doodle – With record option still available with doodle collection
- How the Optimizer chooses Between Indexes and Full-Table Scan
- Choosing the best indexing strategy
- Creating indexes on Nullable Columns
- Oracle 11g RESULT_CACHE Hint : Faster Performance Queries, Advantages, Benefits
- Global Index Vs Local index – Difference, Advantages, Disadvantages, features, examples
- How to get Google Analytics Code again?
- Create PFILE SPFILE from memory 11g New Feature
- Oracle 11g New Feature Parameter DDL_LOCK_TIMEOUT : DDL waiting time for DML Locks
- Troubleshoot & fix ORA-01002: fetch out of sequence
- How to check whether oracle is 32bit/64bit and running OS platform is 32bit/64bit?
- Workaround for ORA-600 [k2vpci_2] SMON Crash and Subsequent startup fails
- Troubleshoot Fix EMCA CONFIG: emca/emcaDbUtil: perl/bin/perl: not found
- Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options Features and examples
- Data Pump EXPDP : How to EXCLUDE table partition explained with example
- How to create and remove soft link (symbolic) in Solaris AIX?
- Troubleshoot Fix emca oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener
- Steps to configure Oracle 11g OEM DBConsole manually for an existing database
- Restrict the commands (SELECT DELETE UPDATE) in SQL*PLUS for a particular user
- Troubleshoot Fix EMCA Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) ORA-01031: insufficient privileges
- RMAN Switch command script to rename the datafile
- ORACLE BASE Vs ORACLE_HOME - Difference between ORACLE_BASE and ORACLE_HOME
- Oracle 10g, 11g User Password Last Modification / Reset time - sys.user$
- How to change or modify the SQLPlus prompt?
- Expdp/Impdp Transportable Tablespace Movement across Different OS Platforms in Oracle 9i, 10g, 11g Examples, Advantages
- Oracle 9i, 10g, 11g: Methods to Rename a username / schema to a new name
- How to Create Virtual Columns with Oracle 11g New Feature?
- SQL Query Check Oracle (9i/10g/11g) tablespace free space and space Usage
- How to Login with more than One (Multiple) Yahoo Messenger simultaneously?
- Oracle 11g New Feature password security dba_users password column is null and stored in user$
- OPatch fails with wrong platform ID (610, 212)
- How to correct & fix the corrupted Oracle (9i, 10g, 11g) inventory using runInstaller & opatch?
- 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?
- DBMS_ROWID for Oracle ROWID Pseudo column Format. Structure, Purpose, Features
- What is Oracle memory HIT and Memory Miss? Buffer Cache, Library Cache, Dictionary Cache HIT Ratio
- Troubleshoot fix resolve ORA-12988: cannot drop column from table owned by SYS. How to drop a column of a table owned by SYS
- what is ORA-00031: session marked for kill , ALTER SYSTEM KILL SESSION, resource busy and acquire with NOWAIT
- Troubleshoot Fix Resolve ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed
- Troubleshoot fix resolve ORA-04091: table scott.EMP is mutating, trigger/function may not see it
- Troubleshoot fix resolve ORA-00936: missing expression
- Troubleshoot Fix Resolve ORA-00060: deadlock detected while waiting for resource
- Troubleshoot ORA-00938: ORA-00939: not enough arguments & too many arguments for function
- Creation, Features of a global temporary table, Privileges to populate
- How to disable flash recovery area of existing open Oracle (10g, 11g) database?
- How to Check Flash Recovery Area Usage for Oracle(10g, 11g) Database?
- How to configure or setup Flash Recovery Area to an Existing oracle (10g, 11g)Database?
- Oracle 11gR2 relink new feature
- How to check patches applied on oracle database? Patch history details
- Troubleshoot Fix Resolve ORA-00054: resource busy and acquire with NOWAIT
- How to disable all constraints on a table or schema - Oracle sql Script
- SET AUTOTRACE EXPLAIN or EXECUTION Plan Options
- RMAN Point in time Recovery (PITR) scenario of a dropped oracle tablespace
- Unix: Command to check swap space in Solaris & AIX?
- Unix: command to check physical memory (RAM) in Solaris & AIX
- Unix: Command to Find out Most CPU Consuming Processes
- Unix: Command to kill multiple processes (pid) in single command
- Windows ORAKILL utility usage-Syntax to Kill Oracle thread
- Data Pump (expdp/impdp) Tuning features - PARALLEL option for faster performance behavior
- Solaris psrinfo to check number of CPU/processors SunOS
- Troubleshoot Fix Resolve ORA-01555:snapshot too old: rollback segment number %s
- Features and configuration of Oracle Automatic UNDO Management AUM
- Functions and Features of Oracle UNDO
- Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded
- DBMS_STATS.export import:How to transfer oracle statistics between databases
- How to rename Oracle Database? Recreate oracle controlfile: Steps to rename the database
- Oracle Imp show=y & Indexfile: How to generate sql scripts from Oracle dump file?
- vi editor mark to create a sub file from main file: explained
- How to open a crashed oracle database during HOT BACKUP
- How to compress export (exp) dump files using UNIX pipes?
- Oracle exp compress=Y Compress option in export (EXP) utility
- UNIX: How to find out the total size of files from multiple directories
- Oracle Data Pump (expdp/impdp) Benefits / Advantages & Disadvantages
- 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
- 5 Different Methods to Partition a non partitioned Oracle table, PARTITION EXCHANGE, SPLIT, Redefinition
- Different types of Oracle Partitioning Range, Hash, List, Interval
- What are the Oracle Advanced Data Compression methodology Tips?
- Trace an Oracle session? DBMS_SYSTEM, DBMS_SUPPORT
acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer