RE: Manager decrees his data warehouse design. Help!

2002-02-27 Thread peter . lomax
. This means that you will have time to perfect a design using a CASE tool. 5. In the end his table could be used as a staging area Just wait don't get annoyed, smile. Just think you can have his job soon. Kind Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau

RE: stopiing write to listener.log

2002-02-07 Thread peter . lomax
Lee, I really don't think that's what he was after. However he does ask an Alice (IWL) and Cheshire cat question. Although yes I did resist the temptation to reply with such flair. Peter -Message d'origine-De: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7

RE: Re[2]: stopiing write to listener.log

2002-02-07 Thread peter . lomax
Nice one, although the pipe still sounds interesting. Peter -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:56 À : Multiple recipients of list ORACLE-L Objet : Re[2]: stopiing write to listener.log Shibu, To get the listener

Converting 32bit to 64bit /Oracle 8172

2002-02-01 Thread peter . lomax
. So I have placed _SYSTEM_TRIG_ENABLED=FALSE in the init.ora and it opens. The dictionary has 58 invalid packages + invalid java packages. Has anyone ever gone thru this sort of a migration. Your comments are truly welcome Regards Peter -- Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI

Boom = Solaris 2.8 Oracle 8172 = Converting 32bit to 64bit

2002-01-31 Thread peter . lomax
gone thru this sort of a migration. Your comments are truly welcome Regards Peter -- Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau: email: [EMAIL PROTECTED] tel:(+33) (0)1 55 22 59 13 fax:(+33) (0)1 55 22 39 69 Simbad sailing through UMTS. -- Please

RE: Unix question

2002-01-28 Thread peter . lomax
Afternoon Roland, Just a couple of hints here. Firstly: Any command that returns an error can be checked for and you can also exit with a code of your choice. so #!/bin/sh export MAILDBA=[EMAIL PROTECTED] sqlplus -s konto/icakort ! set heading off verify off feedback off termout off pages 0

RE: Reporting database with Time Finder

2002-01-16 Thread peter . lomax
Sonja, that is a very interesting question. I have tested the source/target scenario under Digital Unix. We did come across a command that allowed you to mount the devices with the same name on the same server with a mount /ignore(?). There may well be a ruse to rename the whole battle ship. It

RE: Recommenations for a DB conversion using SQL Loaderf

2001-12-14 Thread peter . lomax
Ken , there is only one book. :-) That is SQL*Loader: The Definitive Guide by Gennick, Mishra The pair explain very nice addons and features that are quite useful. As usual its an Oreilly book. Peter Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau

RE: how delete myfile* in unix

2001-12-13 Thread peter . lomax
Hello Sinard, sometimes there are people who create files ll as well. rm 'myfile*' This should do the trick Regards Peter Lomax (Oracle DBA) Expertise Oracle ORANGE/DSI/SIMBAD/ATP OrangeFrance Bureau: email: [EMAIL PROTECTED] tel:(+33) (0)1 55 22 59 13 fax:(+33) (0)1 55 22 39 69

RE: Export question - appending date to dmp file

2001-12-04 Thread peter . lomax
; column member format a50 select 'alter database rename file '''||member||''' to '''||member||''';' from v\$logfile; spool off whisky Regards Peter Lomax (Oracle DBA) Expertise Oracle SG/DSI/SIMBAD/ATP OrangeFrance Bureau: *: - [EMAIL PROTECTED] (: (+33) (0)1 55 22 59 13 fax: (+33) (0)1 55