What is most important work for DBA's ? It is Database BACKUP. There are simple three methods which you can use to take database backup. 1. COLD backup /...
First use "shutdown immediate" command to shutdown database server without "SHUTDOWN ABORT" if shutdown immediate command is HANG then use "SHUTDOWN ABORT" +...
Nice information taj. Babu Mohammad Taj <star_taj@...> wrote: First use "shutdown immediate" command to shutdown database server without "SHUTDOWN ABORT"...
Hello All, I would like to know how to gather statistics on Oracle Application Server, number of concurrent users on the application server. We have Web users...
...I would like to know how to gather statistics on Oracle Application Server,... same like Database Server. Statistics gather only on database, it is not...
Dear Friends, Today I discuss some NETWORK related issues which we database administrator usually faced. First understand which network files is important for...
Thanks for reply... Please check this one also... http://download.oracle.com/docs/cd/B32110_01/core.1013/b28942/monitor _b2.htm#CHDEGJHD Regards Mohammad Taj ...
Nice Info. Taj. We are using Oracle 2003 R2 + Orace 10g R2. And my applicaion is Oracle 6i D2K. While connect my prod. database i'm getting this error msg...
"SYS" is a magic User? Answer: Yes, but why? Why everyone recommended to "don't use sys" user for database activities. Because: 1. SYS (SYSDBA) is super and...
Hi all, I want to know the schemas in particular user after connecting as sys, Because I don't have users passwords to access the user tables. Thanks msd....
Query the USER_OBJECTS data dictionary hth kelvin ... ____________________________________________________________________________________ Looking for last...
User and Schemas is same (no difference) For All objects you can know through 'DBA_OBJECTS' after connecting with any DBA privileged user (don't use SYS user)....
Hello,I have a 7 tables and 140 schema. I do some inserts and updates on table. Is there any way to find out all the inserts and updates on this tables done...
Hello, You have only two options for that. 1. Enable auditing. 2. Create Trigger for capture ALL DML statement. Regards Taj ... updates on table. Is there any...
Dear Friend, I am very much confuse about the user authentication concepts .. Externally- Specifies that the user is authenticated by OS Globally - Specifies...
welcome to oracle club. Yahoo! Groups Notification <notify@yahoogroups.com> wrote: Hello, This is an automated email message to let you know that amjad_ora...
Dear Friends , How to install multiple Oracle version on the same machine like 9i and 10g so that seprate database can be created and managed independently.......
Dear, you need to just use dummy where condition. like sql>--user 1 sql> create table tablename as select * from user2.tablename where 1 =2; above statement...
Dear, Just choose separate ORACLE HOME location during installation for oracle 10g. after that use only one listener for both version. means STOP oracle 9i...
Thanks I will try out your both the answers , CAN I install 10g in the location D:\Oracle\10g\ and my present 9i is in the location D:\Oracle\Ora92\ Regards.. ...
Hi friends, To copy a user's table structure to another user without transfering any data , we can use following procedure:- Here i have created a new table...
Dear friends as you know in Windows Vista Home Premium Edition doesn't exist Local Security Policies. Someone from Microsoft Staff suggested to me to do so: ...
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.
