RE: remove & move a user
Murat, 1) remove a user absolutely. I want to remove the user's tables, indexes, ... etc. DROP USER XYZ CASCADE; 2) move a user absolutely to another tablespace. EXPORT/IMPORT in user mode. Sanjay -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G Sanjay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Index performance
What is the selectivity of the columns emp_st, emp_status and match? If there are just 3-4 distinct values in the column, do not use b-tree index on them. Just drop the Indexes on those columns and try again. If still slow then try bitmap indexes on those low selectivity columns. Sanjay -Original Message- Sent: 23 July, 2002 11:24 PM To: Multiple recipients of list ORACLE-L Hi I am executing following query adn this query hits a number of indices on this table.let me know what is wrong please.all in where clause are having indexes. select name,last_access, reg_date from empmaster where emp_id<100 and reg_date>to_date('2001-01-01','-MM-DD') and emp_st='valid' and last_access>to_date ('2001-01-01','-MM-DD') and emp_status='S' and match='FIRST' Here all conditions in where clause are having indexes. How to rewrite this query. The primary key is emp_id. Thanks -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G Sanjay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export syntax
Did you run catalog.sql which calls catexp.sql? Sanjay -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 23 July, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Oracle Version: 8.1.7 OS : Sun Solaris Shell: ksh the following syntax gives invalid col name : exp test/test file=expt.dmp tables=x1 query=\"where x1_cd in \(\'207\'\)\" EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G Sanjay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: V. Urgent - Got Stuck with trigger
Just realized that alter table disable trigger will not work too.. Even if there is only one session on server it will return more than one row because of BG processes. Sanjay -Original Message- Sent: 22 July, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Hi List, My friend has foll.(Big)problem. He'was testing the following trigger n now stuck. Do not execute this trigger on ur side. CREATE OR REPLACE TRIGGER tpp before alter or create or drop on database declare uname varchar2(20); begin select osuser into uname from v$session; if uname != 'Sachin' then raise_application_error(-20002,'not allowed); end if; end; Now he can't modify/drop this trigger, He gets the follow error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 - One thing I suggested is to make sure that there is only one session on server. Is that possible ? What are the other solutions ?? (Do not execute this trigger on ur side. if u don't know the solution) Thx & Regards, Sam __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G Sanjay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: V. Urgent - Got Stuck with trigger
Try to disable the trigger first then drop it. The error is expected because the SQL in trigger will return more than one row. HTH Sanjay -Original Message- Sent: 22 July, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Hi List, My friend has foll.(Big)problem. He'was testing the following trigger n now stuck. Do not execute this trigger on ur side. CREATE OR REPLACE TRIGGER tpp before alter or create or drop on database declare uname varchar2(20); begin select osuser into uname from v$session; if uname != 'Sachin' then raise_application_error(-20002,'not allowed); end if; end; Now he can't modify/drop this trigger, He gets the follow error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 - One thing I suggested is to make sure that there is only one session on server. Is that possible ? What are the other solutions ?? (Do not execute this trigger on ur side. if u don't know the solution) Thx & Regards, Sam __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G Sanjay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sequence number generation
Generate the sequence with option NOCAHCE The cached values of the sequences are lost if the shared pool is flushed. Sanjay -Original Message- Sent: 18 July, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Hi Is it possible to avoid sequence number loss in the sequence number generation. if so how? Thanks in Advance Ayyappan.S "Dreams translate into thoughts, and thoughts translate into action: Kalam" This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ayyappan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G Sanjay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Insufficient privs when trying to connect via DBA Studio usin
Couple of things to check.. 1. Have you set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE ? 2. Did you follow the path and naming convention for the passwordfile. On Unix it is $ORACLE_HOME/dbs/orapwSID HTH Sanjay -Original Message- Sent: 17 July, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Internal Hi DBAs, I recreated password file using orapwd on Oracle 8.1 for NT. I renamed the old password file and moved the new one over. Reason is password for internal account was lost. Anyway after recreating, I tried to connect as internal thru DBA studio and get insufficient privs. Can you someone help to resolve this. The syntax I used to recreate password file is ORAPWD FILE=PATH\xxx.ora password=new_password entries=5 Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G Sanjay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dblink problem ( ORA-02019 )
Hi, Use this DROP DATABASE LINK name; Or if you have created public link then.. DROP PUBLIC DATABASE LINK name; Sanjay -Original Message-From: Anand Kumar N - Systems [mailto:[EMAIL PROTECTED]]Sent: 16 July, 2002 3:03 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) HI AMJAD, HOW TO DROP THE DATABASE LINK. ANAND ITW SIGNODE INDIA LIMITED - Original Message - From: Amjad To: Multiple recipients of list ORACLE-L Sent: Thursday, July 11, 2002 1:43 PM Subject: RE: dblink problem ( ORA-02019 ) CREATE PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string' Regards, Amjad. www.medicomsoft.com : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list ORACLE-LSubject: Re: dblink problem ( ORA-02019 ) Hi all, How to Create dblink, can u please explain me. bye Anand - Original Message - From: Ratnesh Kumar Singh To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 10, 2002 6:23 PM Subject: dblink problem ( ORA-02019 ) hii have 3 databases(A,B,X) on 3 diff boxes.i have created 1 dblink each from A to X & from B to X.The syntax for dblink creation is exactly same for both dblinks.I am able to query from dblink A-X as "select * from user.table@dblinkAX"but when i try to query from dblink B-X as "select * fromuser.table@dblinkBX"i get the foll errorError: ORA-02019: connection description for remote database not foundWhen i modify my query by suffixing '.world' as"select * from [EMAIL PROTECTED]" , the query works fine.I have compared the entries in init,sqlnet,tnsnmames,listener files on bothA & Bdatabases and they are absolutely similar .i was thinking that the domain or globalnames parameters might be diff on A& B ,but they are absolutely same .any suggestions are most welcome ...thanks in advanceratnesh---Ratnesh Kumar SinghSr. Software EngineerPatni Computer Systems LtdTTC Mahape , Navi MumbaiWork : (91 22) 7611090/110/128/350 Ext. 2107Home : (91 22) 8662162http://www.patni.comWorld-Wide Partnerships. World-Class Solutions.- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).