FAQ

Oracle > oracle-l > January 2001

Search Discussions

775 discussions - 2,559 posts

  • Hi Guys Can any one give me information regarding B2B and B2C solutions. Thanx in advance Rambabu Original Message ----- From: To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 02, 2001 ...
    RambabuRambabu
    Jan 3, 2001 at 8:24 am
    Jan 6, 2001 at 6:01 am
  • Well you can STILL choose the initial/next values for a locally managed tablespace, so choose a reasonable one. I have always been concerned with fragmentation of tablespaces, whether it be lots of ...
    Tim SawmillerTim Sawmiller
    Jan 30, 2001 at 2:47 pm
    Jan 31, 2001 at 7:29 pm
  • I'm getting ready to set up some auditing and in the past I've routinely moved the SYS.AUD$ out of the system tablespace thinking it was the only data dictionary table move supported by Oracle. But I ...
    Steve OrrSteve Orr
    Jan 15, 2001 at 6:39 pm
    Jan 17, 2001 at 12:29 pm
  • Hi gurus, I've just changed jobs quite recently and am already having problems with my Senior Developer (yippee) It concerns the PL/SQL coding style. The guy insists that I use 'SELECT ..INTO ' in my ...
    Chandini PatersonChandini Paterson
    Jan 18, 2001 at 4:01 pm
    Jan 19, 2001 at 2:26 am
  • Hi DBAs, Is there a way to capture the actual sql statement issued while in sql*plus,worksheet,etc? Thanks, Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 ...
    Cale, Rick T (Richard)Cale, Rick T (Richard)
    Jan 16, 2001 at 1:02 pm
    Jan 18, 2001 at 10:50 pm
  • Hi DBAs, I cannot seem to find what the max length of SID is. Is it still 4? I was thinking in one of the newer version it increased in size. Thanks Rick Cale, Science Applications International ...
    Cale, Rick T (Richard)Cale, Rick T (Richard)
    Jan 17, 2001 at 7:33 pm
    Jan 20, 2001 at 3:15 am
  • Hi gurus, Please suggest me a different ways to transfer data from the table to a FLAT file... Thanks Ram Sankaranarayanan
    Sankaranarayanan, RamasubramanianSankaranarayanan, Ramasubramanian
    Jan 12, 2001 at 3:20 pm
    Jan 15, 2001 at 4:47 pm
  • Our Java users are concerned that there may be a possibility that their code may have to work on top of a variety of databases. We use Oracle in-house but we, theoretically, may sell our product to ...
    Seley, LindaSeley, Linda
    Jan 31, 2001 at 1:24 am
    Jan 31, 2001 at 10:52 pm
  • This is a multi-part message in MIME format. --------------AAE721DAA63A3DA5ABA3DEAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, Can anyone answer this question? ...
    Arul kumarArul kumar
    Jan 25, 2001 at 5:31 am
    Jan 27, 2001 at 3:39 am
  • 15

    RMAN

    Hi dear ALL In the svrmgrl: svrmgr connect internal svrmgr shutdown immediate svrmgr startup mount In the RMan: c:\rman nocatalog rman run{ 2 allocate channel t1 type disk; 3 backup database format ...
    Ura!Ura!
    Jan 5, 2001 at 7:34 am
    Jan 31, 2001 at 5:36 am
  • All, One of the applications here has hard coded tablenames of mixed case. How do I get the export command to recognise the mixed case tablenames. At the moment it is coming back with the tablename ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Jan 18, 2001 at 10:45 am
    Jan 19, 2001 at 5:13 pm
  • Hi List, This question has been discussed so many times. But I dont have the trick now. Could you please send me the trick to select top-20 salary of scott.employee table ? Thanks. Aldi Get Your ...
    Aldi BarcoAldi Barco
    Jan 12, 2001 at 9:18 pm
    Jan 16, 2001 at 6:52 am
  • Does anyone know why so many of these Oracle processes named (LOCAL=NO) have suddenly shown up? So many in fact, I can't bring up SVRMGR until I kill them, but they keep coming back! oracle 9739 1 0 ...
    Larry TaylorLarry Taylor
    Jan 4, 2001 at 7:27 pm
    Jan 11, 2001 at 10:21 am
  • Can anyone tell me which would be better to use for copy a 12 gig schema from one 8.1.6 database to any 8.1.6 database, Standby-Database or Replication? I tried to export/import, I lost data and ...
    Larry TaylorLarry Taylor
    Jan 31, 2001 at 5:53 pm
    Jan 31, 2001 at 10:52 pm
  • I have previous officemates who are now in Dubai. They say...the women there is assumed not to be professionally good as men. An Arab interviewer went to my town to interview some prospective ...
    Bmarialuz_at_netscape.netBmarialuz_at_netscape.net
    Jan 26, 2001 at 10:47 pm
    Jan 31, 2001 at 4:40 am
  • Hi everyone, I setup a job in cron that runs an oracle procedure every night at 3am. The procedure deletes all the rows of a table(less than 500 rows) then does an "insert select from a remote ...
    Bonnergj_at_songs.sce.comBonnergj_at_songs.sce.com
    Jan 24, 2001 at 5:37 pm
    Jan 26, 2001 at 8:32 pm
  • I have received a job offer from some company in Bahrain. Perhaps, through their agents. They are saying it to be contract position for 2-3months. I have less than two years of experience on oracle ...
    Mohammad ShujaMohammad Shuja
    Jan 25, 2001 at 5:59 pm
    Jan 31, 2001 at 12:33 pm
  • Does anyone have any stories or advice? I am new to the idea of gateways and Oracle using ODBC or a similar tool to get to external data. Basically I am going to have an Oracle 8.1.7 DB on NT that ...
    Adam TurnerAdam Turner
    Jan 24, 2001 at 6:41 pm
    Jan 25, 2001 at 3:09 pm
  • All, Anyone know how I can select the last Friday in every month from dual. I just can't seem to figure this out. I am trying to test a job that needs to be submitted via dbms_job.isubmit on that ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Jan 23, 2001 at 4:22 pm
    Jan 24, 2001 at 8:40 am
  • Hi, On Solaris 5.7/Oracle 816 (64 bit), I have a server with 3 identical databases. 2 of them have crashed late friday night and I'm not able to start them. I started them but just after the db are ...
    Paquette stephanePaquette stephane
    Jan 15, 2001 at 10:17 am
    Jan 16, 2001 at 1:44 pm
  • Consider a table A : LesseeID BidRate 100 2.4 101 2.5 102 3.5 103 2.4 104 2.4 Now I want to retrieve LesseeId with minimum BidRate however please note that I just need a single LesseeID and that too ...
    Sachin PuriSachin Puri
    Jan 12, 2001 at 9:33 am
    Jan 13, 2001 at 3:56 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C0798C.D783DF20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Dear DBAs ! How can i find out ...
    AndreyAndrey
    Jan 8, 2001 at 2:05 pm
    Jan 8, 2001 at 10:05 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C074CD.C0B24480 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit Can anybody help me identify ...
    John HallasJohn Hallas
    Jan 2, 2001 at 3:07 pm
    Jan 3, 2001 at 5:34 pm
  • I am looking to resolve an issue we have with a particular script. using a unix script, I need to determine if a file exists and if the size of the file is zero bytes. using ftp, we put a file a file ...
    Roy FergusonRoy Ferguson
    Jan 31, 2001 at 7:46 pm
    Jan 31, 2001 at 10:52 pm
  • Anurag, when you say it is not working what do you mean? What errors do you get? Usually these errors will help you/us to pinpoint the cause of these errors. More information is needed Raj Rajendra ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jan 31, 2001 at 5:27 pm
    Jan 31, 2001 at 10:52 pm
  • Hi I installed solaris 5.7 and then applied patches that are recommended for solaris 5.7. after patches are applied and the system is rebooted, cdrom is unreadable and I cannot access that. Is there ...
    Sachin PuriSachin Puri
    Jan 11, 2001 at 8:18 am
    Jan 30, 2001 at 4:43 pm
  • As a part-time dba, I am confused about the differences between Primary Keys and Indexes. For example if I create a table "EMPLOYEES" and in the table creation statement I do something like: create ...
    Wayne McGillWayne McGill
    Jan 10, 2001 at 3:43 pm
    Jan 12, 2001 at 10:49 pm
  • Over the last week or two, our Oracle 8.0.5.2.1 database has been generating an abnormally large number or archive logs. I am compressing the archive logs every 6 hours but still have to mv archive ...
    Roy FergusonRoy Ferguson
    Jan 10, 2001 at 5:11 pm
    Jan 10, 2001 at 10:34 pm
  • Try: exec dbms_output.put_line('.');
    Trassens, ChristianTrassens, Christian
    Jan 9, 2001 at 2:05 pm
    Jan 9, 2001 at 4:05 pm
  • We have a purchased application with over 1,300 indexes. Can someone suggest a method to monitor the system to determine which indexes are actively being used over time? I'm assuming that some are ...
    PRINCE, PATRICK W.PRINCE, PATRICK W.
    Jan 30, 2001 at 8:57 pm
    Jan 31, 2001 at 10:52 pm
  • My personal favorites are the top session monitor, otune32 (the utilities that can be found on Guy Harrison's web site), sqlplus and vmstat/iostat. Statspack and/or utlbstat/utlestat are also ...
    Gogala, MladenGogala, Mladen
    Jan 23, 2001 at 7:19 pm
    Jan 24, 2001 at 11:17 pm
  • Hello all, I found one Oracle Bug while resizing a datafile. Please suggest me what to do. After resizeing a datafile please see the column bytes size and create_bytes size in v$datafile. In my ...
    Dash, Saroj (CAP,CEF)Dash, Saroj (CAP,CEF)
    Jan 16, 2001 at 6:36 am
    Jan 19, 2001 at 3:58 pm
  • Hello, On one of my databases, the SYSTEM tablespace has about 2 GB free space, and just over 50 GB used space. I am trying to reduce the size of the datafile using "alter database datafile ...
    Sam BootsmaSam Bootsma
    Jan 17, 2001 at 3:27 pm
    Jan 18, 2001 at 7:24 pm
  • Once again I solved a SQL*net performance problem where data was being SELECTed via a DB_LINK from a remote system and being INSERTed into the local instance. The original code was going into the ...
    Charlie MenglerCharlie Mengler
    Jan 9, 2001 at 10:08 pm
    Jan 12, 2001 at 9:51 pm
  • So who is going, want to get together for dinner or something, i'll be there, presenting on logminer(I dont think I can milk that topic for many more conferences). Come and see me on tueday at 5P, ...
    Joe TestaJoe Testa
    Jan 10, 2001 at 3:11 pm
    Jan 10, 2001 at 9:21 pm
  • Yesterday someone gave a clean history of how the early Church fathers decided what to put into the New Testament and what to leave out. Here is another version: ... it was in 325CE that the Council ...
    Boivin, Patrice JBoivin, Patrice J
    Jan 9, 2001 at 4:57 pm
    Jan 10, 2001 at 7:32 pm
  • I know this may be a very obvious question, but I need to know what would you use oracle vs. miscrosoft sql? Is microsoft sql capable of storing images? What is the maximum storage for oracle vs ...
    Rivera, ClaudiaRivera, Claudia
    Jan 4, 2001 at 10:16 pm
    Jan 6, 2001 at 5:39 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C08BBD.587423A0 Content-Type ...
    Mohan, RossMohan, Ross
    Jan 31, 2001 at 7:38 pm
    Jan 31, 2001 at 10:52 pm
  • We have a situation where we insert rows into a table, without having knowledge of the primary key. One of our developers needs to determine the rowid of such a row (primary key unknown) immediately ...
    Sam BootsmaSam Bootsma
    Jan 31, 2001 at 6:32 pm
    Jan 31, 2001 at 10:52 pm
  • stephane, just curious, really, no subtle lines... should I, a developer, tell my dba that I'm gonna create temporary tables? (I know most of you are dba's, please don't flame me...) deep inside I ...
    Gabriel GalanternikGabriel Galanternik
    Jan 29, 2001 at 5:18 pm
    Jan 31, 2001 at 8:28 pm
  • Hi all Is it a problem to have oracle 7.3.4 cliënts and a oracle 8.1.7. server enterprise edition, or is it also necessary to upgrade all the cliënts as well. Most of our applications are developed ...
    GKor_at_rdw.nlGKor_at_rdw.nl
    Jan 30, 2001 at 2:57 pm
    Jan 31, 2001 at 3:28 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0814C.F032C7B2 Content-Type ...
    Koivu, LisaKoivu, Lisa
    Jan 18, 2001 at 12:48 pm
    Jan 18, 2001 at 10:05 pm
  • Why doesn't this query ever return... where run_date = to_date('01-03-2001 16:34:59','mm-dd-yyyy hh24:mi:ss') but this query does.... where to_char(run_date) = to_char(to_date('01-03-2001 ...
    Lisa YatesLisa Yates
    Jan 8, 2001 at 7:27 pm
    Jan 8, 2001 at 10:01 pm
  • Hi list, I have some doubts about Oracle Parallel Server(OPS). Could you help me 1 - Is OPS (8.1.6 or higher) available for linux ? If yes.. 1.1 Can I have an OPS without a shared subsystem disks? ...
    Alessandro GuimaraesAlessandro Guimaraes
    Jan 4, 2001 at 8:17 pm
    Jan 8, 2001 at 5:01 pm
  • Hi all, We have an outside vendor developing an application, which we will = ultimately inherit for maintenance. They are porting this application = from a different database platform to Oracle, ...
    Siv ChelakkaraSiv Chelakkara
    Jan 5, 2001 at 6:25 pm
    Jan 6, 2001 at 5:52 am
  • Hi, I have created a bitmap index on a table. The same query behaves differently under various optimisation modes, on 8.1.7 db -desc am33 Name Null? Type ------------------------------- -------- ---- ...
    Amar Kumar PadhiAmar Kumar Padhi
    Jan 15, 2001 at 8:36 am
    Jan 16, 2001 at 4:56 pm
  • Hi all, Big troubles occur after I apllied the 8.1.6.3 patch on an Oracle 8.1.6.2 enterprise edition. Databases are opened, but nothing is working (as PL/sql proc, system views, etc..) any more. All ...
    Pascal dumasPascal dumas
    Jan 11, 2001 at 11:00 am
    Jan 12, 2001 at 4:15 pm
  • Can anyone connect to Peter Loney's web site? Netscape here keeps looking for the host, but can't find it. No DNS resolution or the server is not available. www.lonyx.com <http://www.lonyx.com ...
    Boivin, Patrice JBoivin, Patrice J
    Jan 9, 2001 at 2:57 pm
    Jan 9, 2001 at 8:14 pm
  • gurus, when i issue a select command to display date in mm/dd/yyyy format, the year 1999 is displayed as 2099. select to_char(process_date,'MM/DD/YYYY) from TEST; PROCESS_DATE 01-01-2099 02-03-2000 ...
    Grace limGrace lim
    Jan 9, 2001 at 2:52 am
    Jan 9, 2001 at 2:45 pm
  • Hi all, I'm running Oracle 7.3 on a Windows NT platform. Recently I was trying to increase the size of the roll back segments to make room for a large transaction. Using Oracle Storage Manager, I set ...
    Andersen, Wayne AAndersen, Wayne A
    Jan 8, 2001 at 7:42 pm
    Jan 9, 2001 at 1:23 pm
Jan 2001
12345…16
Group Navigation
period‹ prev | Jan 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions775
posts2,559
users485
websiteoracle.com

485 users for January 2001

Dgoulet_at_vicr.com: 76 posts Koivu, Lisa: 53 posts Mark Leith: 49 posts Jacques Kilchoer: 46 posts Paquette stephane: 46 posts Rachel Carmichael: 46 posts Kevin Kostyszyn: 45 posts Mohan, Ross: 43 posts Trassens, Christian: 40 posts Kimberly Smith: 38 posts Ruth Gramolini: 30 posts Deshpande, Kirti: 29 posts Stephane Faroult: 25 posts Alex Hillman: 24 posts Gogala, Mladen: 24 posts Jkstill_at_teleport.com: 23 posts Sachin Puri: 23 posts Yong huang: 23 posts Boivin, Patrice J: 22 posts Dennis Taylor: 22 posts
show more
Archives