What are the difference between DDL, DML and DCL commands? <http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml\ -and.html> 1)Query-select ...
Dear Taj thank you, in the official documentation I read something like pointers swapping are you sure about this??? Where did you get...
Hi , Is there any difference between backup taken from RMAN in these 2 senarios 1) RMAN hotbackup(i.e. DB in open state) and 2) RMAN coldbackup(i.e. DB in...
Dear friend, Both are same as User Managed COLD or HOT Backup. means If you take backup in OPEN stage then you can recover database at POINT IN TIME. or if you...
Dear, PARTITION is not improve database performance. PARTITION is use for MANAGEBILITY purpose. it is increase database managebility. AFAIK, PARTITION will...
Default Column Values in Oracle. <http://arjudba.blogspot.com/2008/06/default-column-values-in-oracle.htm\ l> In oracle you can use default value of a...
may i know your database version ? select * from v$version? and show parameter compatible Mohammad Kaiz <kaiz_ora@...> wrote: Dear Friends, I was trying...
You mean it right? Afterword I came to know this facility is introduce in 10g and not in 9i; and my version is 9i... still Thanks.... ... Click here....
Dear Friends, Check below link for more information SQL help <http://www.orafaq.com/wiki/SQL*Plus_FAQ#How_does_one_enable_the_SQL.2AP\ lus_HELP_facility.3F>...
Thank you Taj. Very Useful info. Babu Mohammad Taj <star_taj@...> wrote: Dear Friends, Check below link for more information SQL help ... -- Thanks &...
How to Develop efficient Sql Statements. <http://arjudba.blogspot.com/2008/06/how-to-develop-efficient-sql-statem\ ... The query optimizer uses statistics...
Hello , Can you tell me the role of the sqlnet.ora file with respect to Oracle's networking . I know that tnsnames.ora is used at the client side...
sqlnet.ora file is also used in client side, it contain NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME, LDAP, EZCONNECT, etc) and it will say u which file or service...
http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#i479724 Go thorw above link, If you have any doubt/clarification let me know. Babu ...
Hello All, Â Â Â Thanks for your reply on sqlnet.ora . Â Â Â Now one more doubt . Can you help me on clearing confusion between the UNDO SEGMENTS and...
Say yes to Sql*Plus / Sql*Plus Tips Many one do not like Sql*plus to write any Sql. Rather they prefer TODD, tora or any other editing tools to write sql...
Undo Segment & Rollback Segment is same. There might be confusion while undo and rollback segment terms are used interchangeably in db world. It is due to the...
Redo log file is part of database file. without redolog file you can't run your database redolog file basically use for record changes in database which use...
Thanks Taj, for that answer on Undo and Rollback segs . ... From: Mohammad Taj <star_taj@...> Subject: [oracleclub] Re: undo and roll back segments To:...
3) Why is the difference between Direct Path Export and Conventional Path Export ? parameters in export, like : consistent = 2)y , ( what is the purpose of it...
Direct path export is must faster than conventional path when we use CONVENTIONAL path then the following procedure going 1. select statement EXTRACT data from...
redo log files are important for instance recovery . if u have no redo log than u can't recover you instance. and in control file database name and creation...
1) There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No- Archive log mode. How...
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.
