FAQ

Oracle > oracle-l > July 2001

Search Discussions

785 discussions - 3,124 posts

  • My kids keep breaking their DVD movies. Does anyone know a way to make a backup copy of a DVD? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET ...
    Smith, Ron L.Smith, Ron L.
    Jul 31, 2001 at 6:05 pm
    Jul 31, 2001 at 9:36 pm
  • Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: rlsmith_at_kmg.com Fat City ...
    Smith, Ron L.Smith, Ron L.
    Jul 10, 2001 at 3:40 pm
    Jul 11, 2001 at 8:25 pm
  • If you're interested in a great opportunity, then consider this position in Phoenix, AZ with a leading company that needs an Oracle DBA to join its' I.T. staff. We would like to submit someone who is ...
    OraStaffOraStaff
    Jul 5, 2001 at 7:36 pm
    Jul 8, 2001 at 1:53 pm
  • How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L ...
    Erik WilliamsErik Williams
    Jul 13, 2001 at 6:38 pm
    Jul 17, 2001 at 6:30 pm
  • Gurus.... Well the boss is now getting on my back for me to upgrade my OCP to 8i. I know, I know, I wasn't going to, please don't flame me, but work is insisting that I do. So now I'm studying the ...
    Ivan_Rivera_at_doh.state.fl.usIvan_Rivera_at_doh.state.fl.us
    Jul 2, 2001 at 9:23 pm
    Jul 3, 2001 at 8:13 pm
  • HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only ...
    Kimberly SmithKimberly Smith
    Jul 19, 2001 at 3:48 pm
    Jul 23, 2001 at 6:27 pm
  • Anyone know if the standby in 9i can be in readonly mode while the logs are being applied? I've heard about this as being the case and also that this isn't the case. Thanks, Dave Turner -- Please see ...
    David TurnerDavid Turner
    Jul 12, 2001 at 6:24 pm
    Jul 17, 2001 at 3:29 pm
  • Hi Can any one tell me What is the Expansion of ORACLE... I have never ever come across it. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. Ph: 4611323 Extn: 216 Fax: 4611324 < Deewaker ...
    Deewaker G.V.Deewaker G.V.
    Jul 2, 2001 at 9:28 am
    Jul 24, 2001 at 9:27 am
  • 19

    UNIX

    Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the ...
    Richard HuntleyRichard Huntley
    Jul 10, 2001 at 5:45 pm
    Jul 16, 2001 at 7:26 pm
  • ...just kidding, thought that would get your attention. But seriously: does anyone out there use Oracle 8i on AIX 4.3 or 5L? I'd like to chat w/you if so..... Thanks! Ross p.s. hmmm...maybe there ...
    Mohan, RossMohan, Ross
    Jul 25, 2001 at 1:49 pm
    Jul 27, 2001 at 9:42 pm
  • Hello guru's, I am using one database in nonarchive log mode, I want to change it to archive log mode. Platform Windows nt 4.0 Oracle 7.3.0 database size 10GB. Can any body give me the script which ...
    JaiminJaimin
    Jul 4, 2001 at 5:34 pm
    Jul 5, 2001 at 3:45 pm
  • I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader ...
    O'Neill, SeanO'Neill, Sean
    Jul 25, 2001 at 9:21 am
    Jul 26, 2001 at 8:55 pm
  • 15

    Help!

    Malini KrishnamurthyMalini Krishnamurthy
    Jul 10, 2001 at 8:48 am
    Jul 26, 2001 at 2:07 pm
  • Hi again everybody, I'll try to be as descriptive as possible, sorry if I leave anything important out. I have the following function which I'm compiling using PL/SQL Developer (tnx Djordje). CREATE ...
    Oqij4ngfcrweuh001_at_sneakemail.comOqij4ngfcrweuh001_at_sneakemail.com
    Jul 23, 2001 at 5:41 pm
    Jul 23, 2001 at 8:32 pm
  • Good morning everyone, Lucky me, I get to choose the size of the server this company should consider purchasing. I have been poking around on the net for any guidelines - I can make guesses based ...
    Koivu, LisaKoivu, Lisa
    Jul 9, 2001 at 3:05 pm
    Jul 11, 2001 at 7:20 am
  • One of the smaller Physics projects, GLAST (Gamma-ray Large Area Space Telescope) is looking at storing their data in Oracle. The bulk of thge data will be a sky map of individual photons, about 20 ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jul 30, 2001 at 11:23 pm
    Jul 31, 2001 at 9:05 pm
  • I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has ...
    O'Neill, SeanO'Neill, Sean
    Jul 26, 2001 at 7:43 am
    Jul 27, 2001 at 12:27 pm
  • IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session ...
    Joe TestaJoe Testa
    Jul 25, 2001 at 12:02 am
    Jul 25, 2001 at 3:51 pm
  • Listers, For any of you who use Informatica ETL products such as PowerMart and/or PowerCenter, how steep is the learning curve for these products? I know there are lots of variables such as how ...
    Larry ElkinsLarry Elkins
    Jul 5, 2001 at 11:42 pm
    Jul 9, 2001 at 3:10 am
  • We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of ...
    Admin.ISISAFBX01.IS_at_mail.mfinante.gv.roAdmin.ISISAFBX01.IS_at_mail.mfinante.gv.ro
    Jul 16, 2001 at 5:51 am
    Jul 24, 2001 at 7:12 pm
  • Hi all, I was measuring the i/o performance of my scsi drives and I have a quick question that maybe someone could shed some light upon. Currently I am using Ultra 2/Wide scsi conrollers, this is ...
    Kevin KostyszynKevin Kostyszyn
    Jul 11, 2001 at 3:57 pm
    Jul 12, 2001 at 6:37 pm
  • I love doing this: PETA: People Eating Tasty Animals. joe or did i mean petabytes. those are the ones that are also friendly to animals. -----Original Message-----From: Mohan, Ross Sent: Tuesday, ...
    JOE TESTAJOE TESTA
    Jul 31, 2001 at 5:34 pm
    Jul 31, 2001 at 11:40 pm
  • text/plain Hi ALL: attachment: stored
    Helen rwulfjeqHelen rwulfjeq
    Jul 12, 2001 at 10:48 am
    Jul 24, 2001 at 7:01 pm
  • Hi all, A friend of mine is having a problem so I thought I would ask all of you experts a quick question. On a Solaris 8 box running 8.1.7, if a partition fills up, will it crash the box? I know ...
    Kevin KostyszynKevin Kostyszyn
    Jul 19, 2001 at 2:42 pm
    Jul 24, 2001 at 3:05 pm
  • Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w
    Walter KWalter K
    Jul 20, 2001 at 12:22 pm
    Jul 23, 2001 at 12:54 pm
  • I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for ...
    Kempf, ReedKempf, Reed
    Jul 18, 2001 at 4:24 pm
    Jul 19, 2001 at 2:48 pm
  • Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for ...
    Edward W. CarrEdward W. Carr
    Jul 16, 2001 at 8:24 pm
    Jul 18, 2001 at 2:22 pm
  • We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as follows : It appears to be related to dbms_job Can any one help? John Errors in file ...
    John DunnJohn Dunn
    Jul 11, 2001 at 11:36 am
    Jul 11, 2001 at 4:16 pm
  • Could somebody give me support 800 or long dist. phone number. I know that I need to log itar first but this is a damagement request and I cannot find mine. Alex Hillman -- Please see the official ...
    Hillman, AlexHillman, Alex
    Jul 9, 2001 at 7:06 pm
    Jul 10, 2001 at 3:27 pm
  • I'm still slogging away at selection process of DB monitor tool. I'm now at stage where I'm compiling a list of specific tasks I'd like to take the contenders through and score them on same. E.G. Can ...
    O'Neill, SeanO'Neill, Sean
    Jul 31, 2001 at 9:48 am
    Jul 31, 2001 at 9:32 pm
  • Hi all, When I am using dbassist to create "create DB script", First of the script is for something like: CREATE DATABASE .. redo bla bla datafile logfile; Second script ALTER TABLESPACE SYSTEM ...
    SinardySinardy
    Jul 28, 2001 at 3:17 am
    Jul 31, 2001 at 12:09 pm
  • I am currently on a project where I have pretty much completed the logical/physical models. Since the client has there own data modelers, they have reviewed the models and wanted specific changes. I ...
    Grabowy, ChrisGrabowy, Chris
    Jul 24, 2001 at 2:50 pm
    Jul 27, 2001 at 4:07 am
  • Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB, after deletion also it is showing 100MB. What ...
    Rukmini DeviRukmini Devi
    Jul 26, 2001 at 10:28 am
    Jul 26, 2001 at 3:37 pm
  • Hi all, I have two parameter files in two different directories on the same machine. Is there a way I can find out which parameter file is being used by the database. One way I tried was to make the ...
    Shahid NasirShahid Nasir
    Jul 3, 2001 at 8:51 am
    Jul 4, 2001 at 4:40 pm
  • Hello list I have a scenario in which I have to check three tables. If there is record in table A, take it otherwise check table B, if there is record in table B, take it otherwise check table C. Let ...
    Witold.Iwaniec_at_atl.bluecross.caWitold.Iwaniec_at_atl.bluecross.ca
    Jul 3, 2001 at 1:41 pm
    Jul 3, 2001 at 10:56 pm
  • Hi Drop your temporary tablespace and recreate it again is the only way to get rid of one datafile out of a tablespace (Some on this list can probably hack the data dictionary as well but ....) Jack ...
    nlzanen1_at_EY.NLnlzanen1_at_EY.NL
    Jul 3, 2001 at 2:24 pm
    Jul 3, 2001 at 8:23 pm
  • I've a table with the following structure and sample data : Station Emission_Freq Reception_Freq class=270522206-02072001 -------- ----------------- ------------------ STAT1 192.5 193.5 STAT2 193 ...
    ALEMU AbiyALEMU Abiy
    Jul 2, 2001 at 6:48 am
    Jul 2, 2001 at 12:32 pm
  • Hi Xperts, Platform is Windows NT Server SP-6, Oracle Enterprise Edition 8.1.6 Question: How do I know before someone tells me that Oracle is down ( e.g. in Unix we check dbw process ) If Oracle is ...
    Harsh AgrawalHarsh Agrawal
    Jul 31, 2001 at 6:02 am
    Jul 31, 2001 at 6:05 pm
  • I would be curious how one can obtain to be "amoung the best" after a single 7.5 hour course which I assume has an 1 hour lunch when most training does similar in about 80-180 hours. There is some ...
    Christopher SpenceChristopher Spence
    Jul 30, 2001 at 8:29 pm
    Jul 31, 2001 at 3:56 pm
  • Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs ...
    Cale, Rick T (Richard)Cale, Rick T (Richard)
    Jul 27, 2001 at 5:09 pm
    Jul 31, 2001 at 11:44 am
  • Has anyone experienced Oracle sales people gouging each other? Seems like they are getting pretty cut throat. I got one quote for $400,000, and a second quote for less than 25% of that, from two ...
    Koivu, LisaKoivu, Lisa
    Jul 26, 2001 at 2:59 pm
    Jul 30, 2001 at 9:08 pm
  • Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is ...
    SinardySinardy
    Jul 23, 2001 at 12:29 am
    Jul 23, 2001 at 5:57 pm
  • Anyone know how to get yesterdays date in PL/SQL? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: john.dunn_at_sefas.co.uk Fat City Network Services -- ...
    John DunnJohn Dunn
    Jul 23, 2001 at 11:27 am
    Jul 23, 2001 at 3:16 pm
  • Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in ...
    Adrian RoeAdrian Roe
    Jul 20, 2001 at 3:22 pm
    Jul 23, 2001 at 7:39 am
  • One of our programmer had imported a table from ACESS database. When I query user_tables I get following result. SQL select table_name from user_tables where table_name= 'TMP_APRIL' no rows selected ...
    Ari, RamaAri, Rama
    Jul 19, 2001 at 7:53 pm
    Jul 22, 2001 at 5:07 pm
  • Hi, I am looking for a particular field if it exists in a database. How to search all tables for a particular field? Thanks in advance. Igor Get your FREE download of MSN Explorer at ...
    Igor zIgor z
    Jul 19, 2001 at 6:45 pm
    Jul 19, 2001 at 7:56 pm
  • Sometime ago there was a post on how to get the last commands executed in SQL*Plus. It is very similar to doing escape from the UNIX command line.... Do you know how to scroll down the last 10-20 ...
    Rama MalladiRama Malladi
    Jul 18, 2001 at 6:26 pm
    Jul 19, 2001 at 2:26 pm
  • Hi All, i am not sure if this has already been posted or not, but...... --29 June 2001 Oracle8i Database Buffer Overflow Vulnerability Security experts found and disclosed a pair of vulnerabilities ...
    Bill ConnerBill Conner
    Jul 9, 2001 at 4:22 pm
    Jul 18, 2001 at 4:33 pm
  • Ok, so no one liked the InterMedia Question, so let's forget that one. How about this? ONS, ver817....namesctl installs and builds OK, but I cannot get names (name server) to run.....if i run the ...
    Mohan, RossMohan, Ross
    Jul 12, 2001 at 10:10 pm
    Jul 15, 2001 at 4:58 am
  • Greetings, Is there any dictionary table/view where I can query the name of all the tables used by a particular view? The way I do now is : Query the line containing 'from' in text field of dba_views ...
    ASHOKE MANDALASHOKE MANDAL
    Jul 13, 2001 at 2:20 am
    Jul 13, 2001 at 3:05 pm
Jul 2001
12345…16
Group Navigation
period‹ prev | Jul 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions785
posts3,124
users450
websiteoracle.com

450 users for July 2001

Dgoulet_at_vicr.com: 77 posts Rachel Carmichael: 68 posts JOE TESTA: 67 posts Jon Walthour: 66 posts Christian Trassens: 59 posts Christopher Spence: 59 posts Mohan, Ross: 54 posts Deshpande, Kirti: 53 posts Kevin Kostyszyn: 49 posts Kevin Lange: 48 posts Hillman, Alex: 47 posts Thater, William: 43 posts Koivu, Lisa: 40 posts Kimberly Smith: 39 posts Jared Still: 37 posts Guy Hammond: 36 posts A. Bardeen: 35 posts Mark Leith: 35 posts Mercadante, Thomas F: 34 posts Paquette stephane: 33 posts
show more
Archives