Search Discussions

272 discussions - 1,345 posts

  • Hi, this is a conceptual question, if you can please I want to expose a course about 10g new features, and I was thinking when I could say Juan Carlos Reyes ORACLE EXPERT (I'm not going to say that ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Dec 22, 2004 at 2:32 pm
    Dec 28, 2004 at 9:21 am
  • There is a little debate going on here about how best to setup a new system which will consist of IBM pSeries and a Hitachi TagmaStore 9990 array of 144 146-gig drives (approx. 20 terabytes). One way ...
    Stephen LeeStephen Lee
    Dec 13, 2004 at 12:25 pm
    Dec 18, 2004 at 1:47 am
  • We have started using locally managed tablespaces for all new tablespaces. We create the tablespaces with autoallocate. Since the tablespaces are locally managed, is there a need to separate the ...
    Jeffrey BeckstromJeffrey Beckstrom
    Dec 13, 2004 at 1:01 pm
    Dec 14, 2004 at 3:24 pm
  • I have been testing this extensively over the last few months. I do a full table scan with a db_file_multiblock_read_count = 1 and then one = 128( i check the 10046 trace to verify i am getting this ...
    Dec 6, 2004 at 11:26 am
    Dec 9, 2004 at 7:05 pm
  • Hi all, I've been asked to shoehorn a user with "read only" access into a database which wasn't designed to accommodate that. Creating a role with select only on tables and views was easy but I'm ...
    Charlotte HammondCharlotte Hammond
    Dec 16, 2004 at 8:53 am
    Dec 19, 2004 at 4:26 pm
  • Has anyone here installed, or attempted to install 8i on Windows 2003 Enterprise? Problems encountered and success stories both welcome. I need to move an app that is in a 7.3.4 database to 8i. The ...
    Jared StillJared Still
    Dec 10, 2004 at 12:32 pm
    Dec 14, 2004 at 6:03 am
  • Hello list, Are there any good docs on metalink to understand the dumps of oracle datafile & data blocks? I am not able to find any as there are many for trace dumps not for understanding block or ...
    Dec 18, 2004 at 3:39 am
    Dec 26, 2004 at 9:44 pm
  • Have any of you had to define (for SOX or otherwise) what specific operations should be performed by SYS versus other administrative operations that can be performed by a user granted DBA privilege? ...
    Barbara BakerBarbara Baker
    Dec 8, 2004 at 1:10 pm
    Dec 9, 2004 at 1:39 pm
  • Hello List, I am an Oracle DBA and have no SAP experience. We plan to implement SAP on = Oracle soon.=20 Where should I start to learn SAP? Any good books or training classes out t= here? Your ...
    Michael WuMichael Wu
    Dec 9, 2004 at 2:07 pm
    Dec 13, 2004 at 12:35 pm
  • Hey guys, check the following article, Im sure many of you are not going = to be happy at all. GAP -----Original Message----- Oracle Experts express disgust Don Burleson =20 =20 There is a lot of ...
    Aragon, Gabriel (GE Commercial Finance)Aragon, Gabriel (GE Commercial Finance)
    Dec 2, 2004 at 11:37 am
    Dec 3, 2004 at 9:40 am
  • I tried to access our ORACLE server through VPN. The problem I have is "sqlplus" not work, but tnsping work. Network engineer told me he did open port 1521 for me. if I use ORACLE "tnsping" on PC ...
    Dba1 mccDba1 mcc
    Dec 15, 2004 at 7:55 pm
    Dec 17, 2004 at 1:56 am
  • Hello list, I have a question. Lets say I have taken an export (full) and imported into another database (full import), including indexes. Do I have to rebuild all indexes again? Generally, to ...
    Dec 22, 2004 at 1:09 am
    Dec 22, 2004 at 10:11 pm
  • Anyone tried to do this before we've got an emc person onsite trying to help us backup using rman a BCV copy of a database. one of tyhe questions i have is if anyone is doing this. How is the process ...
    Fuad ArshadFuad Arshad
    Dec 22, 2004 at 9:48 am
    Dec 22, 2004 at 10:11 pm
  • Last week I downloaded the 64-bit 10G client from OTN, but then thought = that perhaps the 32-bit client would be better. I could have sworn I = saw one listed. However, when I went back there wasn't ...
    MacGregor, Ian A.MacGregor, Ian A.
    Dec 6, 2004 at 3:31 pm
    Dec 21, 2004 at 5:59 am
  • We have 13 development databases, 8 parallel development tracks, and 2 concurrent sustainment releases all developing at the same time. We are having alot of trouble with change management. I am ...
    Dec 9, 2004 at 4:01 pm
    Dec 12, 2004 at 1:31 pm
  • I wish 9i Release 2, as10g (9.0.4) and em10g (9.0.4) were available for solaris 10 on x86. Patrice. -- http://www.freelists.org/webpage/oracle-l
    Boivin, Patrice JBoivin, Patrice J
    Dec 9, 2004 at 6:05 am
    Dec 10, 2004 at 8:54 am
  • Hi, I have the following table below SQL select * FRom mytable; A B ---------- ---------- 1 2 3 4 2 1 5 6 4 3 5 rows selected. and I like to get the following output: A B ---------- ---------- 1 2 3 ...
    Dec 3, 2004 at 10:38 am
    Dec 3, 2004 at 2:27 pm
  • Recently I was asked to produce a couple of scripts that could be run from the UNIX prompt (or cron) to put all of the tablespaces in a database into backup mode then then put them back into ...
    Stephen boothStephen booth
    Dec 14, 2004 at 6:21 am
    Jan 20, 2005 at 12:22 pm
  • I know this has been discussed here before and i did find a couple of jonathan lewis's old posts The thing is we have a project where the consultants want to ensure about 10-15 foreign keys per ...
    Fuad ArshadFuad Arshad
    Dec 14, 2004 at 10:37 am
    Dec 20, 2004 at 8:37 am
  • Anyone know how to convert a MicroSlop rich text, like a word doc, field into just plain text? And using word in this case is not an option. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- ...
    Goulet, DickGoulet, Dick
    Dec 8, 2004 at 10:56 am
    Dec 8, 2004 at 4:33 pm
  • How does Oracle on Linux treat Intel CPUs with HyperThreading ? Also, does the software license have to be for twice the number of CPUs . I believe that, on a 4-CPU machine, Oracle actually sets ...
    Hemant K ChitaleHemant K Chitale
    Dec 8, 2004 at 10:42 am
    Dec 10, 2004 at 1:35 am
  • If you get this email it is a fraud.... My friend at work just got one. It looks absolutedly perfect but the IP address is not for ebay. If you hit the link is takes you to a site that looks like ...
    Duret, KathyDuret, Kathy
    Dec 8, 2004 at 9:30 am
    Dec 8, 2004 at 8:05 pm
  • Is there anyway to move from a "normal" b-tree index to a locally partitioned index online without having to to a rebuild? We have fairly large databases (15 TB for the one that we are concerned with ...
    Aj wellsAj wells
    Dec 29, 2004 at 7:59 am
    Jan 1, 2005 at 9:09 pm
  • I recently ran accross a SQL by Jonathan that uses "materialize" hint. As was unable to find the hint documented anywhere, and God knows I tried before asking the question, I must ask the folowing ...
    Mladen GogalaMladen Gogala
    Dec 24, 2004 at 11:00 pm
    Dec 29, 2004 at 7:10 pm
  • Hi, 1) exec dbms_stats.gather_schema_stats(ownname = '''||username|| ''',degree= 4,cascade = TRUE,options= ''GATHER STALE''); 2)DBMS_UTILITY.ANALYZE_SCHEMA('USERNAME','COMPUTE'); 3)ANALYZE TABLE ...
    Seema SinghSeema Singh
    Dec 23, 2004 at 2:02 pm
    Dec 27, 2004 at 9:48 pm
  • According to the 9i documentation, you can now grant a column in a table to another user. I can't seem to get the syntax correct. Here is what the fine manual seems to indicate: GRANT SELECT ...
    Dec 21, 2004 at 10:49 am
    Dec 21, 2004 at 7:09 pm
  • Hi, I had been RTFM some hours, and I can find a script to change a constraint this is get the constraint ddl and all the constraints using that constraint Using dbms_metadata I couldn't get foreign ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Dec 17, 2004 at 9:32 am
    Dec 17, 2004 at 2:38 pm
  • Are there any good SQL Tuning courses that are available in the US? We have few Developers who needs to be trained to write efficient and scalable SQLs and i'm looking for suggestions. Thanks, Sriram
    Sriram RamachandranSriram Ramachandran
    Dec 8, 2004 at 9:32 am
    Dec 8, 2004 at 11:43 am
  • Need some space in a hurry, and I'd like to be able to play with RAC over USB/Firewire. This article http://www.oracle.com/technology/pub/articles/hunter_rac.html#Hardware%20&%20Costs recommends a ...
    Paul DrakePaul Drake
    Dec 3, 2004 at 2:31 pm
    Dec 6, 2004 at 10:56 am
  • Hi, What would be the definition of a poorly written SQL? -sql, with wrong join order -sql, which uses dual sql, having no bind variables etc etc. regards, Fahd -- ...
    Fahd MirzaFahd Mirza
    Dec 3, 2004 at 5:13 am
    Dec 6, 2004 at 3:03 am
  • Hi! We just bought two EMC Clariion CX700 boxes as SAN storage. The boxes are primarily used for Oracle databases. Our system integrator is trying to persuade us to use "snaps" for database ...
    Daiminger, HelmutDaiminger, Helmut
    Dec 28, 2004 at 4:08 am
    Dec 30, 2004 at 12:49 am
  • Within Oracle, how can I round up an 8 figure number to the nearest 5000 such that 96136462 becomes 9614000 and 96130045 becomes 96135000? Maths was never my strong point!!!;-) Steve -- ...
    Steve JelfsSteve Jelfs
    Dec 23, 2004 at 6:34 am
    Dec 23, 2004 at 8:24 am
  • I have an Oracle HTTP Server installed from the companion CD on my winXP sp2 laptop. It has stopped serving web pages at all. I have firewall software which is disabled on the laptop, and anyway this ...
    Niall LitchfieldNiall Litchfield
    Dec 22, 2004 at 10:41 am
    Dec 22, 2004 at 2:55 pm
  • I have a many to one relationship from table b to table a. In other words, in table A I have people and in table B I have assignments. I need to write a query to pick up a set of users in table A and ...
    Ben SauerBen Sauer
    Dec 20, 2004 at 1:34 pm
    Dec 20, 2004 at 4:59 pm
  • Hi, I have both oracle 8i and 9i running. I want to update two columns in a table with two different conditions. Is it possible to do it as one sql statment? For example, create table t1 (NOTFLAG ...
    Guang MeiGuang Mei
    Dec 17, 2004 at 11:55 am
    Dec 17, 2004 at 3:41 pm
  • We are looking for a good GUI software application to implement auditing against our Oracle databases. Ideally it would use a central repository and have canned reports. It needs to run against ...
    Smith, Ron L.Smith, Ron L.
    Dec 16, 2004 at 8:10 am
    Dec 17, 2004 at 6:09 am
  • Can anyone check and tell me whether Oracle added a timestamp column to the dba_errors view? Just curious. Patrice. -- http://www.freelists.org/webpage/oracle-l
    Boivin, Patrice JBoivin, Patrice J
    Dec 14, 2004 at 10:25 am
    Dec 14, 2004 at 11:45 am
  • I'm trying to run the Installer from home, installing on a remote Unix server. I've always used ipconfig to locate my laptop's IP address, then set the DISPLAY variable on the server to 'IP':0.0 ...
    Dec 12, 2004 at 9:51 am
    Dec 13, 2004 at 8:26 am
  • I think this was answered before on this list (or I heard it in a class) but I can't seem to find it. I recall there being a table that can be queried to determine which events are set in the ...
    Dec 7, 2004 at 11:11 am
    Dec 8, 2004 at 7:14 am
  • Hi Friends, I would like to know the list of "NOT TO DO" on Primary database in Standby database environment. And how to rectify, in case, it's done. i have a partial list like ... NOLOGGING, CLEAR ...
    Prem Khanna JPrem Khanna J
    Dec 7, 2004 at 4:37 am
    Dec 7, 2004 at 10:57 am
  • Hi list, We need to do a point-in-time restore of one of our 9.2i databases to Monday 3 p.m. The last two backups was performed Sunday night and Friday night and all the archived logs are in the ...
    Roger XuRoger Xu
    Dec 1, 2004 at 3:05 pm
    Dec 2, 2004 at 9:52 am
  • Hi all, Select count(*) from all_sequences=20 return 0 Select count(*) from dba_sequences=20 return correct # of sequence Sinardy -- http://www.freelists.org/webpage/oracle-l
    Sinardy XingSinardy Xing
    Dec 1, 2004 at 10:57 am
    Dec 1, 2004 at 11:30 am
  • I have a need to regularly Recreate certain Indexes . {see note below on WHY !} This is scripted. However, the script sometimes errors on the DROP with ORA-0054 and, of course, the CREATE doesn't go ...
    Hemant K ChitaleHemant K Chitale
    Dec 31, 2004 at 9:13 pm
    Jan 5, 2005 at 6:21 am
  • Yes, I realize "it depends" on many factors. Assume sufficient CPU, RAM & I/O exist; a lightly loaded OLTP system For the query below what is the rough order of magnitude for rows/second being read 1 ...
    Sol beachSol beach
    Dec 30, 2004 at 8:35 pm
    Dec 31, 2004 at 9:37 pm
  • Is anybody using index skip scan feature? What would be a situation in which the feature should be used? I have a SQL statement, part of ETL process that I have to tune. The initial reuslts are ...
    Mladen GogalaMladen Gogala
    Dec 29, 2004 at 12:46 pm
    Dec 30, 2004 at 6:04 pm
  • I am trying to clear my concept on what BAST (blocking asynchronous system trap) is and how it works in RAC. I have not been able to find much information on Metalink. I would appreciate if someone ...
    Hameed, AmirHameed, Amir
    Dec 23, 2004 at 8:50 am
    Dec 25, 2004 at 1:31 pm
  • Got a client who has one piece of code that somehow got its plan changed to something horrible. The only thing I noticed was they changed an index name from "JIMBO" to UQ_CF.......IX We rebuilt the ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Dec 13, 2004 at 8:36 pm
    Dec 22, 2004 at 10:07 am
  • Hi all, We are currently using Oracle Designer to design and generate our database objects. Because we've begun adding other databases to our portfolio (mySQL, SqlServer and Sybase), we can't depend ...
    Vanessa A. SimmonsVanessa A. Simmons
    Dec 16, 2004 at 11:07 am
    Dec 17, 2004 at 3:08 am
  • Hi All, We have 2 node OPS( with client. Since OCI has some problem oracle recommended to use JDBC THIN driver as a work around. Howevery we have to have failover functionality as ...
    Sami SeeranganSami Seerangan
    Dec 13, 2004 at 12:27 pm
    Dec 14, 2004 at 9:07 am
  • Which is a better method to backup the recovery catalog? By logical or physical backup? Horror stories? Good ones? rcat db os Linux SUSE 8 target dbs and os: SunOS 2.8 ...
    Carmen RusuCarmen Rusu
    Dec 13, 2004 at 2:44 pm
    Dec 13, 2004 at 3:59 pm
Group Navigation
period‹ prev | Dec 2004 | next ›
Group Overview
grouporacle-l @

279 users for December 2004

Jared Still: 63 posts Mladen Gogala: 39 posts Post, Ethan: 35 posts Hollis, Les: 31 posts Niall Litchfield: 31 posts David Sharples: 23 posts Goulet, Dick: 22 posts Johnson, George: 22 posts Juan Carlos Reyes Pacheco: 21 posts Mercadante, Thomas F: 21 posts Rjamya: 20 posts Lex de Haan: 19 posts Stephen booth: 18 posts Jonathan Lewis: 17 posts Reidy, Ron: 17 posts DENNIS WILLIAMS: 16 posts Matthew Zito: 15 posts Wolfgang Breitling: 15 posts Bobak, Mark: 14 posts Boivin, Patrice J: 14 posts
show more