Search Discussions

430 discussions - 2,173 posts

  • I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just ...
    Orr, SteveOrr, Steve
    Jun 4, 2003 at 3:40 pm
    Jun 13, 2003 at 9:40 am
  • Friends, James Morle has done it again. Nobody does it better. For the first public showing of his BAARF animation, please GoTo www.MiracleAS.dk . Then get back to your work or mailing list fast ...
    Mogens NørgaardMogens Nørgaard
    Jun 10, 2003 at 9:47 pm
    Jun 25, 2003 at 11:40 pm
  • WILL OPEN-SOURCE THREATEN ORACLE, IBM AND MS? | Internet News How big of a threat are open-source databases to software giants like Oracle, who hold most of the market and revenue share today? MySQL ...
    Ron RogersRon Rogers
    Jun 17, 2003 at 6:24 pm
    Jun 20, 2003 at 8:22 pm
  • We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is there a way oracle can authenticate from windows ( or active directory ) ...
    Jun 19, 2003 at 5:04 pm
    Jun 30, 2003 at 9:07 pm
  • Mladen: Prior to 8i (or 8) you see the multiblock sequential reads while doing the reads from the sort segments or temporary segments. But in 8i sort IO is done as direct IO and we see some other ...
    K GopalakrishnanK Gopalakrishnan
    Jun 12, 2003 at 7:47 am
    Jun 13, 2003 at 6:37 pm
  • Hi, I would like to know if it is possible and what the pitfalls are if I do the following. Partition a large table into partitions based on date. Data is only entered and read and never altered, so ...
    Jack van ZanenJack van Zanen
    Jun 18, 2003 at 2:11 pm
    Jun 19, 2003 at 5:40 pm
  • Seems to be taking awfully long to read files from tape and write to disk. I allocate multiple tape channels like I do for the backup which only takes about 45 minutes. Does not seem to be spawning ...
    Jun 4, 2003 at 1:24 am
    Jun 5, 2003 at 6:59 pm
  • There appears to be a number of folks on the list who have some insight into the next version of the database. I'd like to ask those folks a simple question. What is the future of the Rule Based ...
    Goulet, DickGoulet, Dick
    Jun 10, 2003 at 4:32 pm
    Jun 16, 2003 at 1:35 pm
  • We are starting a project that will eventually have 500 laptops wandering around in the wild. These will have an Access database for untethered use, and will periodically connect to Oracle via Net8 ...
    Jun 12, 2003 at 5:49 pm
    Jun 13, 2003 at 4:18 pm
  • Hi all, If you are installing or upgrading 9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be installed? I am talking about regatta (p690) servers if that matters ... Thanks in ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jun 2, 2003 at 12:39 pm
    Jun 30, 2003 at 7:04 pm
  • Hi gurus, anyone knows of a possibility to directly send data to :LPT1 ? I am in the need of printing online when something definite happens to the DB........... TNX Confidentiality Notes This email ...
    Jun 27, 2003 at 12:12 pm
    Jun 30, 2003 at 3:33 pm
  • Oh-My-Gosh. Worry free? I just upgraded another database to 9.2. When I set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors: ORA-00402: database ...
    Koivu, LisaKoivu, Lisa
    Jun 4, 2003 at 2:40 pm
    Jun 5, 2003 at 7:20 pm
  • Hi! I am new using Oracle, and what to ask some doubt about indexes How can I see how many fields of a table have indexes? I am trying to do an update but is too slow, so what I am trying to find is ...
    Teresita CastroTeresita Castro
    Jun 24, 2003 at 11:06 pm
    Jun 27, 2003 at 9:13 pm
  • Any Good Docs, Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 ...
    Jun 23, 2003 at 7:19 am
    Jun 26, 2003 at 6:56 am
  • Hi Group, I wanted to do my 9i OCP. I have not taken any of the 8i OCP exams. To do 9i Exams directly I need to attend module 3 or 4 or New features from any of the Oracle Edu Partners. Shall I take ...
    Senthil Kumar DSenthil Kumar D
    Jun 25, 2003 at 4:24 pm
    Jun 27, 2003 at 6:20 am
  • Hello, I joined this list last week, so I apologize in advance if I'm asking a question that has previously been answered. I am responsible for a reporting database/data mart that is approximately ...
    Bart KersteterBart Kersteter
    Jun 25, 2003 at 2:05 pm
    Jun 26, 2003 at 3:34 am
  • Hi list, SCENARIO LAB DB = Oracle on Suse Linux 7.2 PRODUCTION DB = Oracle on HP-UX B.11.00 I have this strange case, I have this query that generate a text file and in the ...
    Ramon E. EstevezRamon E. Estevez
    Jun 27, 2003 at 8:43 pm
    Jun 30, 2003 at 4:39 pm
  • hi all: I need to move a SYSTEM datafile from a filesystem to a raw device. I have shutdown the database, copied the file via dd if=system of=/dev/raw renamed the file in the database, but couldn't ...
    Jun 19, 2003 at 6:08 pm
    Jun 22, 2003 at 10:22 am
  • I have procedure that needs to pass a string with a ' . Anyone have any idea how to do this in PL/SQL Here is my example: var a refcursorvar b varchar2(100);begin :b :='and ...
    Laura penaLaura pena
    Jun 10, 2003 at 4:37 pm
    Jun 11, 2003 at 3:05 pm
  • Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison ...
    Jesse, RichJesse, Rich
    Jun 20, 2003 at 5:35 pm
    Jun 23, 2003 at 11:16 pm
  • I've just discovered this, never thought if it was possible or not. Just wanted to share it with you, so forgive me if you know it already. Procedure can contain other procedures: create or replace ...
    Khedr, WaleedKhedr, Waleed
    Jun 3, 2003 at 11:09 pm
    Jun 5, 2003 at 3:40 pm
  • I've been fighting an ongoing war with our ecommerce developers, who are inordinately fond of writing dynamic SQL code that neglects to incorporate bind variables. Researching AskTom I've found and ...
    Thomas JeffThomas Jeff
    Jun 25, 2003 at 3:12 pm
    Jun 26, 2003 at 2:53 pm
  • When NOT Giving any Order by Clause, How is the Output of the SELECT Clause ordered by Default ? Assuming There exists a Unique index on the Table Is some Rule followed ? NOTE Records may have been ...
    Jun 25, 2003 at 2:05 pm
    Jun 26, 2003 at 6:52 am
  • Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them ...
    Ruth GramoliniRuth Gramolini
    Jun 17, 2003 at 1:33 pm
    Jun 19, 2003 at 6:45 pm
  • Hi!! I was working with SQL Server 2000, and now the company decided to change to Oracle. So I don't know much about Oracle, I am just reading a book and try to find information on the net. I am ...
    Teresita CastroTeresita Castro
    Jun 10, 2003 at 1:36 am
    Jun 12, 2003 at 12:18 am
  • I have a cust pounding a Sun E450 I believe they said it was with a large RAID with fiber channels. They pound this thing at 2,037 I/O per seconds and end up having about 3,868 I/O per data block ...
    Michael KlineMichael Kline
    Jun 9, 2003 at 4:36 pm
    Jun 11, 2003 at 4:45 pm
  • What are the restriction in naming an Oracle SID/Database? Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? What is the maximum size of a SID/Database name ...
    Mandal, AshokeMandal, Ashoke
    Jun 30, 2003 at 3:26 pm
    Jun 30, 2003 at 10:46 pm
  • I need help with clearing up one conceptual issue: My understanding is that with Oracle RAC one set of physical database files "sitting" in the "middle" - shared storage are being accessed by ...
    Branimir PetrovicBranimir Petrovic
    Jun 25, 2003 at 2:45 am
    Jun 25, 2003 at 11:43 pm
  • While not trying to sound like this is coming off like a shameless plug, because it isn't... I have an Apps book going to publisher in a couple weeks and they want to do PR. To that end, they have ...
    April WellsApril Wells
    Jun 9, 2003 at 3:25 pm
    Jun 10, 2003 at 1:18 am
  • Hi list, Can you help me please . I have a report that show data as follows : debit credit balance 3 0 -3 0 -1 2 1 0 3 Is their a way to get balance without using a separet query in a formula ...
    Walid AlkaakatiWalid Alkaakati
    Jun 4, 2003 at 1:10 pm
    Jun 5, 2003 at 11:23 pm
  • I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every now and then everything appears to be hung and then, 10 ...
    Mladen GogalaMladen Gogala
    Jun 17, 2003 at 2:47 am
    Jun 17, 2003 at 7:47 pm
  • Guys, CONNECT SYS AS SYSDBA; create user testuser1 identified by testuser1; grant connect, resource to testuser1; create user testuser2 identified by testuser2; grant create session to testuser2 ...
    Prem Khanna JPrem Khanna J
    Jun 13, 2003 at 3:21 am
    Jun 17, 2003 at 1:16 am
  • OK, I'm confused. Maybe it's Monday morning and my brain's not working. We have a production schema and a test schema on the same Oracle 8.1.7 instance, running on Windows. They both have a customer ...
    Craig HealeyCraig Healey
    Jun 2, 2003 at 1:45 pm
    Jun 9, 2003 at 7:01 pm
  • This was just passed on to me and I'd like to share it wit the list... http://www.palaydium.net/tech/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET ...
    Bob MetelskyBob Metelsky
    Jun 18, 2003 at 3:33 pm
    Jun 30, 2003 at 9:44 pm
  • Goodday all We have cutomer who is having a database which should be available 24x7. Now we can't get even a maintenance time to do the database. We tried on several occasion but nothing happens. Now ...
    Jackson DumasJackson Dumas
    Jun 25, 2003 at 9:20 am
    Jun 30, 2003 at 8:31 pm
  • to get OCM you need to take 2 advanced classes then pass an all day comprehensive hands on test right? what do they have you do for that test? i heard there are different OCMs? btw, how much does it ...
    Jun 25, 2003 at 7:15 pm
    Jun 26, 2003 at 5:00 pm
  • how to find folder size in unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 ...
    Jun 26, 2003 at 10:17 am
    Jun 26, 2003 at 4:44 pm
  • Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET ...
    Jun 24, 2003 at 1:37 pm
    Jun 24, 2003 at 8:04 pm
  • I hate to be a spoilsport, but some people unfamiliar with the USA might be taking this seriously. This is, of course, a humorous piece, in the same vein as the joke about Microsoft purchasing the ...
    Jacques KilchoerJacques Kilchoer
    Jun 20, 2003 at 6:54 pm
    Jun 23, 2003 at 10:30 pm
  • does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example, SUN,IBM,HP,LINUX? SUN,HP?etc,etc Thanks in advance!! Greg
    Loughmiller, GregLoughmiller, Greg
    Jun 17, 2003 at 6:18 pm
    Jun 19, 2003 at 5:25 pm
  • I'm trying to create a materialized view on a 7G table. I'm using UNDO and undo_retention=108000, which if I understand correctly is 30 hours. I have 7G in UNDOTBS1 --- I shouldn't need that much ...
    Thomas DayThomas Day
    Jun 18, 2003 at 2:25 pm
    Jun 19, 2003 at 3:16 pm
  • Just in the mood to do one of these.... Which of the following is *not* a feature of Oracle 9i? The ability to Rename a Column The ability to Rename a Constraint The ability to rename a tablespace ...
    Freeman Robert - ILFreeman Robert - IL
    Jun 13, 2003 at 7:36 pm
    Jun 14, 2003 at 10:29 pm
  • Among some of the "Rube Goldberg" applications around here, is one that has multiple replication clients that subscribe to a master. For whatever reason, we might have a client not update for a while ...
    Stephen LeeStephen Lee
    Jun 12, 2003 at 7:20 pm
    Jun 13, 2003 at 4:49 pm
  • I have to tell you this, my friends: Today, a package arrived here in Maaloev on the oak table. It contained Oracle version 5.1.C and 6.0 on 5.25'' diskettes. The sender was Chris G. from Nokesville, ...
    Mogens NørgaardMogens Nørgaard
    Jun 3, 2003 at 10:19 pm
    Jun 7, 2003 at 7:45 pm
  • Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately ...
    Jun 4, 2003 at 12:59 pm
    Jun 6, 2003 at 12:16 am
  • My boss has decided to change the name of the Sun OS 2.8 host of my Oracle 8i databases. Question: how does this name change affect my Oracle software installation and my databases? Has this happened ...
    Carmen RusuCarmen Rusu
    Jun 3, 2003 at 3:24 pm
    Jun 4, 2003 at 3:10 am
  • Hi All, I keep getting a cannot allocate new log in the alert log. This freezes the entire application and I am unable to connect to oracle in order to do a statspack snap shot. This is an upgrade to ...
    Nuala CullenNuala Cullen
    Jun 2, 2003 at 2:19 pm
    Jun 2, 2003 at 7:14 pm
  • Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence ...
    Reddy, MadhusudanaReddy, Madhusudana
    Jun 10, 2003 at 6:32 pm
    Jun 29, 2003 at 4:38 am
  • Hello All, We have Oracle ( 8.1.7 ) running on HP-UX and experiencing HP-UX Error: 23: File table overflow errors, so initially we have bumped the nfile kernel parameter to 128 K. Just couple of days ...
    Reddy, MadhusudanaReddy, Madhusudana
    Jun 25, 2003 at 4:36 pm
    Jun 27, 2003 at 1:22 am
  • Is it possible to connect to database using encrypted passwords? Using sqlplus? Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jun 19, 2003 at 12:53 pm
    Jun 21, 2003 at 4:06 am
Group Navigation
period‹ prev | Jun 2003 | next ›
Group Overview
grouporacle-l @

314 users for June 2003

DENNIS WILLIAMS: 93 posts Jamadagni, Rajendra: 66 posts Gogala, Mladen: 58 posts Goulet, Dick: 54 posts Arup Nanda: 51 posts Stephen Lee: 51 posts Jacques Kilchoer: 43 posts Jared.Still_at_radisys.com: 42 posts Ryan: 42 posts Richard Ji: 33 posts Mogens N?rgaard: 32 posts Rachel Carmichael: 32 posts Mladen Gogala: 28 posts Jesse, Rich: 26 posts Tanel Poder: 26 posts Igor Neyman: 25 posts Kirtikumar Deshpande: 25 posts Naveen Nahata: 25 posts Bulbultyagi_at_now-india.net.in: 24 posts Freeman Robert - IL: 24 posts
show more