RE: a little sql question
set feedback on Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : lundi 3 septembre 2001 10:30 À : Multiple recipients of list ORACLE-L Objet : a little sql question hi every body, I need to insert in the end of a sql script, the number of rows returned. how can i do that ? thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim 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: INF/MEKKAOUI 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: MOVE Tables from One Tablespace to Another Tablespace !!
hi, the command is : Alter table table_name move tablespace tablespace_name; But be careful from index corruption. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Dash, Saroj (CAP,CEF) [mailto:[EMAIL PROTECTED]] Envoyé : mardi 21 août 2001 08:16 À : Multiple recipients of list ORACLE-L Objet : MOVE Tables from One Tablespace to Another Tablespace !! Hello All, Please tell me the detailed steps to move tables from one tablespace to another tablespace. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) 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: INF/MEKKAOUI 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: Lost of all Control Files
hi, if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine-De: Ramon Estevez [mailto:[EMAIL PROTECTED]]Envoyé: mercredi 15 août 2001 14:22À: Multiple recipients of list ORACLE-LObjet: Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: Metablink .... down again?
it's working again Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : James Howerton [mailto:[EMAIL PROTECTED]] Envoyé : lundi 23 juillet 2001 14:56 À : Multiple recipients of list ORACLE-L Objet : Re: Metablink down again? Its not you, Metablink is crawling on its knees again. ...JIM... [EMAIL PROTECTED] 7/23/01 9:20:32 AM Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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: James Howerton 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: INF/MEKKAOUI 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: resize in 7.3.4 urgent
: data file number: 'full_path_name' ORA-09971: sfsfs: write error, unable to write header block. If you check V$DATAFILE, you will see that the file size does not change unless the operation is successful. Finally, if using multiple database writers (db_writers 1), you might run into [BUG:311905]. This appears as ORA-7374 errors when accessing the datafile after it has been resized. The workaround is to shutdown and restart the database after resizing a datafile (a convenient time to take a backup). This will cause the new datafile size information to be refreshed to all the dbwr slave processes. This bug is fixed in RDBMS version 7.3.3. MANUAL versus AUTOMATIC extension: Be careful giving datafiles the AUTOEXTEND attribute, certainly specify the NEXT and MAXSIZE parameters, set appropriate values for the default storage parameters on tablespace level and MAXEXTENTS; for objects in these tablespaces specify explicitly INITIAL and NEXT extent size as well as MAXEXTENTS; avoid UNLIMITED sizes and extents to prevent objects with a very high number of extents will be created; this causes not only a huge number of records in the dictionary tables, but dropping them will take a very long time while smon is consuming all cpu resources it can get. FINDEXT.SQL Script to find database object locations for a given datafile. ---CUT-CUT-CUT REM findext.sql REM REM This script prompts user for a datafile ID number, and REM then lists all the segments contained in that datafile, REM the blockid where it starts, and how many blocks the REM segment contains. It shows the owner, segment name, and REM segment type. REM REM Janet Robinson Stern April 2, 1997 REM variation on Cary Millsap's script REM SET ECHO OFF ttitle - center 'Segment Extent Summary' skip 2 col ownr format a8 heading 'Owner'justify c col type format a8 heading 'Type' justify c trunc col name format a28 heading 'Segment Name' justify c col exid format 990 heading 'Extent#' justify c col fiid format9990 heading 'File#'justify c col blid format 0 heading 'Block#' justify c col blks format 999,990 heading 'Blocks' justify c select owner ownr, segment_name name, segment_type type, extent_id exid, file_id fiid, block_id blid, blocksblks from dba_extents where file_id = file_id order by block_id / -CUT--CUT---CUT-- Example Output: SQL @findext.sql Enter value for file_id: 5 old 12: file_id = file_id new 12: file_id = 5 Segment Extent Summary Owner Segment Name Type Extent# File# Block# Blocks --- -- --- USER EMP TABLE 0 5 25 USER TAB3 TABLE 0 5 1085 USER TEST TABLE 0 5 3485 USER PK_EMP INDEX 0 5 4835 USER EMP TABLE 1 5 4335 USER EMP TABLE 2 5 438 10 USER PK_EMP INDEX 1 5 488 10 References: === [BUG:311905] RESIZING DATAFILE - NEWSIZE NOT REFRESHED FOR SLAVES IF USING MULTIPLE DBWRITERS Search Words: = RESIZE SHRINK FILE DATAFILE ALTER ORA-923 ORA-3297 ORA-1237 ORA-1110 ORA-9971 . -- end note Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : mardi 17 juillet 2001 17:05 À : Multiple recipients of list ORACLE-L Objet : resize in 7.3.4 urgent hi, i want if any body try to resize a datafile to a lower value. i'm on oracle 7.3.4 on hpunix 10.0 thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim 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: INF/MEKKAOUI 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
RE: Problem connecting to a db
set your ORACLE_SID in the registry to the SID you want to connect. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Steven Hovington [mailto:[EMAIL PROTECTED]] Envoyé : mardi 17 juillet 2001 12:30 À : Multiple recipients of list ORACLE-L Objet : Problem connecting to a db I have someone on a remote site who is having problems connecting to a db in server mgr as internal. connect internal should work, but it replies with insufficient privileges, I must be missing something. Does anyone have a suggestion what this could be? OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as administrator. Thanks, Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: INF/MEKKAOUI 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: Temp
hi, Moi aussi, je suis ravie . Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : GL2Z/ INF DBA BENLATRECHE [mailto:[EMAIL PROTECTED]] Envoyé : lundi 16 juillet 2001 09:46 À : Multiple recipients of list ORACLE-L Objet : RE: Temp Hi Content d'avoir de tes nouvelles From Oracle Documentation (Server Concept) , there is no effect of quotas on temporary segments. -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : lundi 16 juillet 2001 09:00 À : Multiple recipients of list ORACLE-L Objet : Temp hi every body, I have a user with no quota on it's temporary tablespace. is it normal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim 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: GL2Z/ INF DBA BENLATRECHE 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: INF/MEKKAOUI 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: Privilege problem ?????
Hi, it depends on what contains this script : for dba operations give them the necessary DBA privileges or sysdba or sysoper for ddl then give them system privileges like create table, index, ... for dml then give them object privileges as select, update on Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Andrea Oracle [mailto:[EMAIL PROTECTED]] Envoyé : mardi 10 juillet 2001 23:00 À : Multiple recipients of list ORACLE-L Objet : Privilege problem ? Hi all, I wrote a script for developers to run. I have svrmgrl, connect internal in the script. The developer got error since he doesn't have privileges. So how to make the script runnable by non dbas??? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: INF/MEKKAOUI 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: How set Date format Globally
Hi, or set NLS_DATE_FORMAT in the registry (32 bits) or oracle.ini (16 bits) in all clients. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Vladimir Begun [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 11 juillet 2001 09:56 À : Multiple recipients of list ORACLE-L Objet : Re: How set Date format Globally On Jul 11, 2001 at 12:35:21AM, Rangachari Sundar wrote: Hi, I have a requirement. Everytime when i make a session to the database i want the Date Format to beas follows '-mm-dd hh:mi:ss' The existing default format is 'dd-mon-' and so I tried the following steps. ALTER SESSION set NLS_DATE_FORMAT='-mm-dd hh:mi:ss' and put that in the login.sql it worked fine for my every client session. How can I set it globally so that everytime when I make a session to database from any client It should be '-mm-dd hh:mi:ss'. Set NLS_DATE_FORMAT in init.ora Would be cool to use dbms_session.set_nls in your logon trigger but it does not work correctly. See bug 1574885, if it's published already. (it was not). Search over metalink for examples. -- Vladimir Begun | There's a lesson here. Generalizations are http://vbegun.net/ | generally useless unless used. http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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: INF/MEKKAOUI 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: How set Date format Globally
oh yes but if in a client the parameter NLS_DATE_FORMAT is set to another format , the generic format set in init.ora is not taken. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 11 juillet 2001 14:06 À : Multiple recipients of list ORACLE-L Objet : Re: How set Date format Globally I believ that you can also set this in the init.ora file, I know that I do:) KK - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 11, 2001 7:40 AM Hi, or set NLS_DATE_FORMAT in the registry (32 bits) or oracle.ini (16 bits) in all clients. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Vladimir Begun [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 11 juillet 2001 09:56 À : Multiple recipients of list ORACLE-L Objet : Re: How set Date format Globally On Jul 11, 2001 at 12:35:21AM, Rangachari Sundar wrote: Hi, I have a requirement. Everytime when i make a session to the database i want the Date Format to beas follows '-mm-dd hh:mi:ss' The existing default format is 'dd-mon-' and so I tried the following steps. ALTER SESSION set NLS_DATE_FORMAT='-mm-dd hh:mi:ss' and put that in the login.sql it worked fine for my every client session. How can I set it globally so that everytime when I make a session to database from any client It should be '-mm-dd hh:mi:ss'. Set NLS_DATE_FORMAT in init.ora Would be cool to use dbms_session.set_nls in your logon trigger but it does not work correctly. See bug 1574885, if it's published already. (it was not). Search over metalink for examples. -- Vladimir Begun | There's a lesson here. Generalizations are http://vbegun.net/ | generally useless unless used. http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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: INF/MEKKAOUI 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: Kevin Kostyszyn 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: INF/MEKKAOUI 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: sql-query
How to use Minus select art_grp from rh minus select art_grp from rik2.katsett_hgr; Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : mardi 3 juillet 2001 13:51 À : Multiple recipients of list ORACLE-L Objet : sql-query Hallo all you gurus, Anyone whom can help me withthis? I would like to see even art_grp that exists in rh but not in rik2.katsett_hgr. How can I change this select statement? select hgr, rh.VGRP, ART_GRP,TEKST from rik2.hierarki_tekst rh,rik2.katsett_hgr where rh.vgrp(+) =rik2.katsett_hgr.vgrp and rik2.katsett_hgr.sett_id=1 and rh.landkode = 47 order by hgr,vgrp,art_grp Roland Sköldblom -- 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: INF/MEKKAOUI 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).
imp-00002: échc d'ouverture de k:\ora
Hi, I performed an import job in oem 2.1 of some tables oracle database 7.3.2 into oracle 8.1.6 schema , the size of dump file is 10k, the dump file is in an other server novell 5.1 in a volume NWFS, for the link i mapped a virtual drive K, but the job failed in oem console with : --- D:\Oracle\Ora81\network\agentimp [EMAIL PROTECTED] file=K:\oramaj\exp12_05.dmp fromuser=user_gl1k touser=test log=D:\oracle\ora81\pexe\tlx3.log ignore=y Import: Release 8.1.6.0.0 - Production on Di Mai 20 13:56:08 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connecté à : Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production IMP-2: échec d'ouverture de K:\oramaj\exp12_05.dmp pour lecture Fichier d'import : EXPDAT.DMP ps : RDBMS Version: 8.1.6 Operating System and Version: Windows 2000 Error Number (if applicable): imp-2 Product : imp Product Version: 8.1.6 And the same job succeed when the dump file is in local drive NTFS. best regards, Nabila Mekkaoui dba oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INF/MEKKAOUI 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: database links
hi millie, you must verify that the host name is resolved in the unix platform(DNS), otherwise put the physical adress in the description of the host. Best Regards, Nabila Mekkaoui DBA -Message d'origine- De : Chan, Millie [mailto:[EMAIL PROTECTED]] Envoy : vendredi 6 avril 2001 19:51 : Multiple recipients of list ORACLE-L Objet : database links We are setting up a test Oracle 8i (8.1.7 with OSDI) on our mainframe (os/390 v2.8), we can connect to the database instance (ORS1) from windows NT client, but when we try to connect to it using database links set up from our unix platform, we get ORA-12154 TNS: Could not resolve service name When we try to link from ors1 I get: ORA-02019 Connection Description For Remote Database Not Found. We created a tar with Oracle and waiting to hear from them. Just wondering if anyone on the list has the same problem? Millie Chan Rutgers, The State University of New Jersey Administrative Computing Services 65 Davidson Road Piscataway, NJ 08855 Tel: (732)445-5433 EMAIL: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chan, Millie 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: INF/MEKKAOUI 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).