Dear Friends, How to find the time duration of log switch so that we can increase or decrease the redo log files and what should be the appropriate duration of...
Hello, Anybody can tell me at which step (nomount, mount, open) password file is checked?? Best Regards, Pranab. ... You rock. That's why Blockbuster's...
Dear, Password file is check in every stage. ( nomount, mount , open) whenever you try to connect using password file authentication. ... is checked?? ... ...
Just observe the alert log file in the bdump directory . There u'll observe the rate at which log switch is occurring . And the minimum recommended by Oracle...
Dear Friends... I am trying to clear my concepts... When user entered the records in a table and issues a commit statement.... the changed records in the SGA...
Dear Friends, how to drop the entire database including all the files ....in 9i one method I know is usind DBCA , is their any other way... While reading new...
Dear All, i had a 10.2.0.3.0 production db running on Redhat AS 5,i had taken cold backup of my production db Now i want to clone production db using this cold...
Hi, I had seen a posting for dropping a database..it is here- Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:\Documents and...
1. Create Password file. 2. %oracle_home\dbs\ - here put your pfile. ( put your controlfie,redo and datafile in corresponding location) 3. create new instance...
Good Reply Babu, If you cloning your database on windows then it is correct steps and if you clonning your database on linux then just SKIP 3 step becuase...
Redo content only commited data and Undo content only uncommited data when user issue commit statement then commited data only transfer to redolog files. ... ...
Hello All, We use FUNCTIONS in PL/SQL. It is one of the subprograms we use in PL/SQl. And we can use them in SQL statements unlike procedures and those are...
Yes taj. Your correct. Mistakenly i mention. Babu Mohammad Taj <star_taj@...> wrote: Good Reply Babu, If you cloning your database on windows then it is...
Dear Prachi, Are you sure ...I got compiled without any errors,... SQL> create or replace function func_chk (no1 number, no2 out number) 2 return number 3 as...
Hello, I need to know how i can create control file from backup trace file. and how i find out the last trace file that contain the last status(control file), ...
Hi Taj, I am sorry. What I wrote is : create or replace function func_chk (no1 number, no2 out number) return number as begin no2 := no1 + no1; return no2; ...
Dear, There is two option for create controlfile. 1. binary file. 2. text file. 1. How to create binary file. SQL>alter database backup controlfile to...
...Does that mean we can not execute function with OUT parameter... Yes correct, we can't use OUT,IN OUT parameter with function. we use only IN parameter with...
Thanks a lot Taj, you are sooooooooooooo quick. I am checking it. Mohammad Taj <star_taj@...> wrote: ...Does that mean we can not execute function with...
Hello, I want to know something about synonyms. I have 3 database users & I created one public synonym for a table & granted access for this synonym to all the...
Always remember. We can't create same name object in same schema/user. ...And now i create a private synonym of the same name in the 4th user, can I create...
Hi Taj, You said Always remember. We can't create same name object in same schema/user. Ok, agreed. But we can create a synonym for a table with the same name...
Dear Prachi, ...But we can create a synonym for a table with the same name as the table.... Don't confuse. I said. SAME OBJECT. and table or synonym or view or...
Hi, Just issue SYS>STARTUP MOUNT RESTRICT SYS>DROP DATABASE. All the DB with all the files will be dropped. --- On Thu, 3/4/08, kaiz_ora <kaiz_ora@...>...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
