Logo
  • Home
  • About me
  • Articles
  • Books
  • Scripts
  • Forums(OTN)
Logo
  • Home
  • About me
  • Articles
  • Books
  • Scripts
  • Forums(OTN)

oracle

All Oracle posts

Administrationoracle

DROP DB_LINKS of a PRIVATE user from “SYS”

DROP DB_LINKS of a PRIVATE user from “SYS” Create a procedure named “DROP_DBLINK” which will call values from “dba_users”, also which parse a cursor in it and it calls an inbuilt package also. To drop a private DB_LINK either we need to change user password or we need to know user password, Instead of that

  • nassyambasha@gmail.com
  • February 21, 2012
  • 3
  • 1
  • 28K
  • 1
  • 2
  • 3
  • …
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81

Recent Posts

  • bookauthority.org: Our book is, #1 in100 Best Oracle Database Books of All Time
  • Troubleshooting Database Cloud Provisioning – Worthy TIP
  • Which Primary Shards dependent to Which Standby Shards? – Oracle Sharding 12.2
  • How to start the full stack of Sharding Database
  • Dissolving Sharding Configuration
  • Troubleshooting Sharding Deployment
  • Resetting the status in DGMGRL – GDS
  • EM12c – Webtier is unable to start
  • Riding on two horses – ODA Database Patching
  • TFA is now optional with Oracle 12.2 RDBMS Installation

Recent Comments..

  • nassyambasha@gmail.com on Script to Monitor Primary and Standby database(s)
  • nassyambasha@gmail.com on Automatic password file synchronization with Oracle Data Guard 12.2
  • Azhar on Automatic password file synchronization with Oracle Data Guard 12.2
  • Balraj Singh Chahal on Script to Monitor Primary and Standby database(s)
  • Balraj Singh Chahal on Script to Monitor Primary and Standby database(s)

Blogroll

  • Charles Hooper's Oracle Notes
  • Christian Antognini Blog
  • Ed Stevens Blog
  • hemant chitale blog
  • Jonathan Lewis
  • Mahir M. Quluzade
  • Michael Seberg
  • Mohammed Houri
  • Riyaj Shamsudeen Blog
  • Syed Jaffar Hussain Blog
  • Tanel Poder Blog
  • Thomas Kyte
  • Uwe Hesse Blog

Popular Articles

AIOUG – Chennai Chapter First Meet

  • oracleUncategorized
  • 4

bookauthority.org: Our book is, #1 in100 Best Oracle Database Books of All Time

  • 12cAdministration
  • 0

Troubleshooting Database Cloud Provisioning – Worthy TIP

  • Uncategorized
  • 0

Which Primary Shards dependent to Which Standby Shards? – Oracle Sharding 12.2

  • 12cData Guard
  • 0

How to start the full stack of Sharding Database

  • 12cData Guard
  • 2

Nassyam Basha – CKPT

Nassyam Basha is a database administrator. He has about 10 years of IT experience, with the last eight years as a production Oracle DBA. He started working with dBase and FoxPr and has participated in several projects with FoxPro and Oracle Database starting from Oracle 7. He is an Oracle 11g Certified Master and was awarded the Oracle ACE Director title from Oracle. He is skilled with Oracle technologies such as Data Guard, RMAN, RAC, Cloud Control, and performance tuning.

Recent Posts

  • bookauthority.org: Our book is, #1 in100 Best Oracle Database Books of All Time October 3, 2020
  • Troubleshooting Database Cloud Provisioning – Worthy TIP May 6, 2018
  • Which Primary Shards dependent to Which Standby Shards? – Oracle Sharding 12.2 March 25, 2018

Twitter Feed

Copyright ©2017 Oracle-ckpt.com. Designed by Casis