‘database’ Archives
Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time
Few days back I got a request from development team to generate hourly export dumps of few schemas. Following were the requirements: 1. Dumpfile name should contain current date and timestamp information. 2. The generated dumpfile should be moved to a specific location. 3. [Read More]
Cloning database..Just do some Post checks !!
Well I will be covering some points which I believe should be part of post checklist for any cloned database environment. This might not be complete list as it contains point which I have encountered or heard of. 1) Change database Name and Database Id You should try to [Read More]
You Don’t need SysDBA privilege to run Awrrpt..
Well I tried to Sensationalize this post by using such a heading Though I just wanted to point out that Awrrpt script can be run without sysdba privilege too. Actually if you open awrrpti.sql script , it contains following line Rem NOTES Rem Run as SYSDBA. Generally this [Read More]
ORA-1078 ORA-1565 Errors while starting database with SPFILE on ASM
I was getting following error’s while starting a database using spfile on ASM. Actually this was a cloned RAC environment. SQL> create SPFILE='+ASM_GROUP/PORTALDB/spfileportaldb.ora' from pfile; File created. SQL> shut immediate; ORA-01109: database not open [Read More]
Scheduling Job through Cron??
In case you came across this link searching for Cron syntax, then you can refer to following link http://www.adminschoice.com/docs/crontab.htm Other’s can continue reading the article …. This was a problem which I faced yesterday. We had a mview refresh which [Read More]
Input is too long (> 2499 characters) – line ignored
There are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve this issue. Copy the code in Text file and while in escape mode enter following command [Read More]
