Re: SQL LOADER

Hi, I am trying to assign a default value for a column from my sequence and i am unable to do that. How do you give it in the control file? Thanks in advance. Regards Sundar Mercadante, Thomas F wrote: >IA, > >like this: > >( col1 char , > col_seq "test_seq.nextval" >) > >where test_s

SQL *Loader commit problem [urgent]

Hi ALL, I am using "direct path" method of SQL *Loader. I am testing for a data file of 1 records. Here when I test at onsite there was one bad file generated with 1 bad record. My log file showed rows loaded properly and 1 record not loaded due to data errors. When I check the count o

Return VArray to Java through JDBC?

Does anyone has the similar experience? I plan to write a stored procedure to return 3 arrays. It works fine in the database. But if I call it from Java codes, I got tons of errors. (the JDBC drivers is from Web Logic, not from Oracle). It would be wonderful if anyone is willing to share the code

Re: Help

I heard that! We got bit on 8.1.7.1 by a 'Cache Buffer Chains' latch contention bug (bug 1967363) that is not fixed until 8.1.7.3 or 9.0.2. The releases are supposed to be out in January, IIRC. --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>

RE: [Q] how to export "sequence number"?

Thank you for your answer. The proble I have is NOT export. I checked export log and found "sequence" actually export, but on import (user mode) it did NOT create 'sequence". >From: "Deshpande, Kirti" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-

RE: [Q] how to export "sequence number"?

Oracle exports sequences in the full or user(e.g. owner=scott)level exports. I would run 'strings' command to scan the dump file to make sure the sequences are there (strings exp.dmp | grep -i sequence). If those are not there, then the export was probably done at table level. If the sequence was

RE: Weid exp/imp problem

Title: Weid exp/imp problem You may need to use consistent=y on the export to ensure that the view for the entire export run is from one snapshot in time.  If your application is busy changing data during the export, then as export moves through the list of tables (alphabetically I think) th

RE: Enable Constraint

If it's a simple 'alter table enable constraint' then it's not building an index, and doesn't even require one on the child table. Jared DENNIS WILLIAMS

Re: WHICH SID

Jeremiah Wilton wrote: > > Both of these work, but are inefficient for repeated frequent use by > an application: > > select sid from v$session where audsid= userenv('sessionid'); > select sid from v$mystat where rownum = 1; > > This is the most efficient: > > select ksusenum from x$ksumysta w

RE: WHICH SID

-Original Message- Sent: Wednesday, December 19, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Why not just: select sid from v$session where audsid= userenv('sessionid'); Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORA

RE: WHICH SID

Both of these work, but are inefficient for repeated frequent use by an application: select sid from v$session where audsid= userenv('sessionid'); select sid from v$mystat where rownum = 1; This is the most efficient: select ksusenum from x$ksumysta where rownum = 1; You need to be SYS or have

Patchset (was RE: Help)

The base release is 8.1.7[.0.0] Applying patchsets change the 4th number, eg 8.1.7.1, or 8.1.7.2 The 5th number is reserved for port (ie OS) exceptions, fixes specific to each platform. On platforms like Unix, individual patches on top of the patchset can be applied (relinked) without changi

strange characters in Oracle Apps printing

After installing Oracle Financials Application 10.7 char on HP-UX 11, we observe that there are strange characters are printed on first page of Report printed through application. If same is printed through unix lp command same are not printed. So where to look and fix that. For comparison pur

RE: WHICH SID

Way much better :) Thanks. I forgot about mystat view.. - Kirti -Original Message- Sent: Wednesday, December 19, 2001 3:12 PM To: [EMAIL PROTECTED] select distinct SID from v$mystat; "Deshpande, Kirti" wrote: > > Try this: > > select sid from v$session > where audsid=(select user

SOLVED: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Tom, At first, he said, no, he had checked that, but (as we know often happens), he rechecked and saw that a higher level calling procedure was set at the smaller size. So your suggestion did lead to the solution. Thanks! Marc Perkowitz - Original Message - To: <[EMAIL PROTECTED]> Cc: <

Re: WHICH SID

Why not just: select sid from v$session where audsid= userenv('sessionid'); Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 3:50 PM > Try this: > > select sid from v$session

RE: unused blocks BELOW HWM - Thanks

Here's what I use. Shows above and below HWM. I have another one for partitioned tables. Hope this works for you. declare OP1 number :=0; OP2 number :=0; OP3 number :=0; OP4 number :=0; OP5 number :=0; OP6 number :=0; OP7 number :=0; free_blocks number :=0; cursor object_cursor is sele

Re: brain F*rt question

Ron Rogers wrote: > > Stephane , > Thanks for the reply. > I tried using a join function and I got the sum(data) I wanted but it listed the >date twice, Once for each table select. In your reply you mentioned a percentage >calculation problem.??? I think the sums are wrong because they get s

Re: Redo logs lost, old backups

Post, Actually I did try. database was opened successfully, but when I query dba_data_file, all the files are disabled. (RBS from recover status to disabled, other files from read/write to disabled ) From that point, I stoped (I don't have time) I am waiting somebody else to tell me. Joan "Post

RE: Problem with job

Are you submitting the job as the perfstat user? Tim -Original Message- Sent: Wednesday, December 19, 2001 12:26 PM To: Multiple recipients of list ORACLE-L > "Daiminger, Helmut" wrote: > > Hi! > > I created a new job in a database: > > variable jobno number; > begin > dbms_job.subm

RE: WHICH SID

Try this: select sid from v$session where audsid=(select userenv('sessionid') from dual); - Kirti -Original Message- Sent: Wednesday, December 19, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi How do find own session id? Thanks -sEEMA __

RE: Error in Package

Thanks Yuval   that worked !!!   Regards,,   Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Yuval ArnonEnviado el: Wednesday, 19 December, 2001 2:51 PMPara: Multiple recipients

RE: 9i

No undocumented features to become troublesome? -Original Message- Sent: Wednesday, December 19, 2001 1:43 PM To: Multiple recipients of list ORACLE-L I have it running on AIX 4.3, we didn't have much problems though ... Raj __ Rajend

Re: brain F*rt question

Stephane , Thanks for the reply. I tried using a join function and I got the sum(data) I wanted but it listed the date twice, Once for each table select. In your reply you mentioned a percentage calculation problem.??? I think the sums are wrong because they get summed for each occurance of

RE: Importing Access tables in Oracle

I other words the table names are case sensitive. But the issue you are running into is this: You currently try and receive an ora-942 select * from tablename; When you should do: select * from "TableName"; MicroSoft products (whether access or sql server) will cause this. Goo

RE: Max data file size on NTFS partition

For what it is worththe largest datafile I have created on a NTFS partition has been 10gig...not sure what the max is, would be interested to know. I think the max size for FAT is 4 gig. Not sure though. thanks, C- -Original Message- Ashley Sent: Wednesday, December 19, 2001 9:16 AM

RE: Error in Package

Check the definition for COMPROBANTES_RECORD and the SELECT statement.   You have one extra column AGENCIA   in the record which is not in the SELECT..   Yuval. -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 19, 2001 2:13 PMTo: Mul

Re: Palladium Consulting

Yep I got one. ...JIM... >>> [EMAIL PROTECTED] 12/19/01 6:50:18 AM >>> Did anyone get an e-mail from Palladium Consulting lately? Just wondering where they got my e-mail address. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://ww

RE: Mabye OT: Was Re: Different clocks for different instances.

Ah, but check 10/5-16/1582 for Oracle. That is when the Gregorian calandar was adopted. 1752 is just for England (I believe).   Henry -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 19, 2001 12:09 PMTo: Multiple recipients of

RE: WHICH SID

For what operating system? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Régio

Re: Importing Access tables in Oracle

You are learning the hard way. NEVER, NEVER, NEVER create tables in Oracle by exporting from MS Access via ODBC. Access creates non-SQL compliant objects. To access these tables you will need to select "Field", "Field" from "Table Name"; using the exact spelling and case as displayed in Access.

Fw: standby on same server

Hello DBAs,   This procedure outlines how to establish a standby database on the same server as the production database. However, it naively assumes that extended production downtime is a non-issue!   Is it possible to establish a standby database on the same box as the production database w

RE: Enable Constraint

Erik - I would assume that underneath Oracle is creating an index. One thing to check is the SORT_AREA_SIZE for your database. If it is the default (64K), then building an index can take a long time. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday

RE: 9i

I have it running on AIX 4.3, we didn't have much problems though ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD

RE: Redo logs lost, old backups

Please provide an update as to whether this worked or not, I would be interested in knowing. Thanks, Ethan -Original Message- Sent: Wednesday, December 19, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Hi Maser, I am not sure this work or not. Actually my suggestion is call o

Enable Constraint

I am having problems re-enabling a foreign key constraint on a large table. The table with the foreign key constraint has 20M rows and the parent table has 1M rows. The foreign key constraint references the primary key of the parent table. I am surprised that the re-enabling is taking so long - 25

WHICH SID

Hi How do find own session id? Thanks -sEEMA _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROT

Re: Max data file size on NTFS partition

I don't have any problems with 5GB files (564K to be precise, LMT tablespace) on 8.1.5, NT. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 2:00 PM > I have had problems c

Re: How to backup MTS database with RMAN

Title: How to backup MTS database with RMAN Hi, Hulmet, I tried.  To use RMAN on MTS database environment, both database server machine and the RMAN machine(the machine you run RMAN on it) should use dedicated server mode instead of shared mode. It means the tnsnames.ora file on these two mac

RE: Importing Access tables in Oracle

Ensure all table names and column names in Access are in uppercase. If not they will be created in your Oracle data dictionary as lower case which is bad. To drop the tables you will need to do drop table "tblFoo"; as opposed to the normal drop table foo or drop table FOO not the use of t

RE: Help

Dennis, There is an 8.1.7.2 superpatch which can be downloaded from Metalink's patch GUI. We have applied that here. I would assume that there is also and 8.1.7.2.1 patchset that you apply over the top of that. Cherie Machler Oracle DBA Gelco Information Network

RE: Max data file size on NTFS partition

Thanks for replying Ed. We did set disable AUTOEXTEND once we realized it was playing one of the "starring" roles in our problem. I opened TAR in Metalink and I'll post the answer when I get a response. Thanks, Ashley -Original Message- Sent: Wednesday, December 19, 2001 12:47 PM To:

RE: ORA-06502: PL/SQL: numeric or value error: character string b

Mark, Your friend does not say how large the variable is, being referenced by the 'out' parameter. My guess is that it is varchar2(256). Have him simply increase the size of the variable in the calling procedure to accomodate the data, and all should be well. HTH Tom Mercadante Oracle Certifi

Importing Access tables in Oracle

Dear all, I have a lot of tables built in MS Access. Recently, I am trying to export the database from MS Access to Oracle 8i.From Access, I could export the tables to Oracle through Oracle ODBC driver. The good thing is that this process is relatively fast as Table struture is created automatica

RE: Max data file size on NTFS partition

I have had problems creating files above the 4G limit with NTFS. Even files above 2GB were sometimes difficult. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com

Error in Package

Hi List,   I spent my morning checking the package trying to figure out what the error is and couldn't find it.  Need some help !!     1  --  2  -- Paquete para Mantenimiento Tabla de Comprobantes  3  --  4  CREATE OR REPLACE PACKAGE MANTENIMIENTO_COMPROBANTES  5 AS  6   TYPE COM

9i

Good Afternoon I am being faced with the 'opportunity' to likely have to install 9i on our production box. I don't have a test environment on which to install. We are running on AIX. Does anyone know what issues exist with 9? Yes, I know that they are going to release another version after

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I am posting this for a co-worker. Anyone seen this before? Seems like there should be an easy answer to this. It's Oracle 8.1.7 on Redhat Linux. Thanks, Marc Perkowitz I am receiving the following Oracle error from a PL/SQL procedure when it attempts to execute a line of code like this: p_

RE: Encryption - Question about the key

No problems with this system; troubleshooting has not been an issue. The key is actually also stored in management's hidden place of choice (I have no knowledge; it's probably in all likelihood either a cleartext file in email or on a few people's hard drives.) But changing keys is something we'

Perl DBI broken after 8i upgrade

Hi Ethan, It's great that you and Jared's responses are so quick. Here are the answer : - The 'make test' run without error. - The new version of perl is the first in the PATH. The old perl still exists and also in the path. When type which perl, the system rerturn the new perl - The l

RE: Help

Dennis, Well, as far as I know, you download it from Oracle's download web-site. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 19, 2001 12:43 PM To: Multiple recipients

Re: Mabye OT: Was Re: Different clocks for different instances.

Wel. I feel enlightened. And more secure! Now the Y1752 / Y1582 bugs won't bite me either! : ) "Schilling, Ben" wrote: > Oracle uses the original start date of the Gregorian calendar in October > 1582: > > 1* select to_date('04-OCT-1582'), to_date('04-OCT-1582')+1 from dual

RE: Help

Download it from Metalink from the patches section. -Original Message- Sent: Wednesday, December 19, 2001 11:43 AM To: Multiple recipients of list ORACLE-L Paul - How does one get 8.1.7.2.1? We ordered 8.1.7 recently from Oracle, but outside the CD just says 8.1.7. Do I need to download

RE: Encryption - Question about the key

Well, The database we are talking here is basically athlete's information who compete in various games. I (and others in the DBA group) can be trusted to hold the key, so that isn't a problem either. There will always one person available who will have access to key if something needs to be fixe

RE: Help

oracle's banner rarely agrees with the actual revision that you are running. I think that it just indicates the base rev, without the patches. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: W

RE: using MTS on oracle OPS, running on HP-UX

Why do you need to use MTS? Do you run out of memory? -Original Message- Sent: Wednesday, December 19, 2001 9:09 AM To: Multiple recipients of list ORACLE-L Hello, Anyone out there try and implement MTS on OPS ? We are using 64-bit HP-UX, rev 11.0, and the OPS is 8.1.6.3.0. We look to

Re: Max data file size on NTFS partition

Hi Ashley, Sorry, don't know exact answer, but the problem doesn't always come from OS side. There are *Oracle* limits on some platforms. It seems you use AUTOEXTEND=ON for your files. If so then you may encountered some bugs when your files had extended through size limits. At least there were

RE: Mabye OT: Was Re: Different clocks for different instances.

Oracle uses the original start date of the Gregorian calendar in October 1582: 1* select to_date('04-OCT-1582'), to_date('04-OCT-1582')+1 from dual devp> / TO_DATE('04-OCT-1582 TO_DATE('04-OCT-1582 04-OCT-1582 00:00:00 15-OCT-1582 00:00:00 Ben Schill

Re: Mabye OT: Was Re: Different clocks for different instances.

Brian McGraw wrote: > > Speaking of the system clock, here's something interesting that I > stumbled across a few years back... > > Background: For those of you who may not know, the Julian calendar > was abandoned by England, in favor of the Gregorian calendar, in 1752 > because of date discre

RE: Encryption - Question about the key

Jared (King of all Perl and Oracle)... I have a guy I work with sitting next to me who is having some problems with getting DBI to work after an Oracle 8i (8.1.7 HPUX) upgrade from 8.0.6. Everything worked fine before the upgrade. Oracle was installed in a new home. Perl was also installed in a

RE: Help

Upgrade first to 8.1.7.2.1. Don't wait. -Original Message- Sent: Wednesday, December 19, 2001 9:09 AM To: Multiple recipients of list ORACLE-L Gene, You may have a longer wait than January if you are non-Solaris. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 7

RE: Help

About a month ago, I upgraded from 8.1.7.1.0 to 8.1.7.2.1 (actually the banner says 8.1.7.2.0). Everything is good so far. Bing -Original Message- Sent: Wednesday, December 19, 2001 9:09 AM To: Multiple recipients of list ORACLE-L Gene, You may have a longer wait than January if you

RE: Converting from ASCII7 to UTF8

Title: RE: Converting from ASCII7 to UTF8 This can be done pretty easily using SharePlex for Oracle.   It's able to replicate between different character sets, platforms, DB versions..  It can also handle your long columns as well.  As for the concern of database space...  you'll probably ga

RE: Help

Paul - How does one get 8.1.7.2.1? We ordered 8.1.7 recently from Oracle, but outside the CD just says 8.1.7. Do I need to download something? Sort of a silly question, but maybe someone else is as dumb as I. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

Re: Problem with job

> "Daiminger, Helmut" wrote: > > Hi! > > I created a new job in a database: > > variable jobno number; > begin > dbms_job.submit (:jobno, 'statspack.snap;', sysdate, 'trunc > (sysdate,''HH24'') + trunc ((sysdate - trunc (sysdate, > ''HH24''))*96+1)/96'); > > commit; > end; > > The job was suc

RE: Mabye OT: Was Re: Different clocks for different instances.

Well I say,   that is also the case on Tru64 as well.   How pedantic is UNIX ??   -Original Message-From: Brian McGraw [mailto:[EMAIL PROTECTED]]Sent: 19 December 2001 16:16To: Multiple recipients of list ORACLE-LSubject: Mabye OT: Was Re: Different clocks for different

RE: Help

Gene, You may have a longer wait than January if you are non-Solaris. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 19, 2001 11:27 AM To: [EMAIL PROTECTED]; [EMAIL PROTE

RE: sql loader-dates

Use DATE "mm/dd/", This should work. Also, look into getting the book "SQL*Loader The Definitive Guide" from O'Reilly. Hope this helps, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -Original Message- Sent: Wednesday, December 19, 200

Re: brain F*rt question

Ron Rogers wrote: > > List, > I am having a big brain F*rt on a simple join query. I would like some input please. > Two tables with common fields "retnbr and saledate" and other fields. I would like to > select the saledate, sum of selected fields from table 1 and selected fields from >table 2

e: using MTS on oracle OPS, running on HP-UX

Hello, Anyone out there try and implement MTS on OPS ? We are using 64-bit HP-UX, rev 11.0, and the OPS is 8.1.6.3.0. We look to go with MTS after we are at 8.1.7.2.1, sometime next month. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL

Re: sql loader-dates

Try using the to_date command for the column data in question in your control file: ex: load data append into table xxx trailing nullcols ( column1 terminated by "," "to_date(:column1,'mm/dd/')", column2. ROR mª¿ªm >>> [EMAIL PROTECTED] 12/19/01 10:45AM >>> Hi , In my data file i have

utl_http package

>Hello Gurus, > >I am working on a little project using the package utl_http, so far I have >had limited success using this package. >The below http call fails for some reason, it is supposed to download a >page of size ~10K, i.e. 5 pieces of data, but instead it fails, I am not >sure why... >

Resend: Re: unused blocks BELOW HWM - Thanks

This is a GREAT idea. Ed > On Wednesday 19 December 2001 00:15, Hallas John wrote: > > I agree with your reasoning Dennis. I have long felt that one of the > > problems with the list is that the original raiser of the question should > > have some sort of responsibility for summarising the var

Max data file size on NTFS partition

Hello to all my most favorite DBAs... Yes, believe it or not, I checked the archives, Metalink and Oracle documentation, but all come up with a different answer to my question. What is the max data file size for an NTFS partition on Advanced Server? I'm running Oracle 8i Release 2 8.1.6 Standar

RE: Help

I am still waiting for Oracle 8.1.7.3 final release for 8.1. Then start looking at 9.1, when it comes out. >>> [EMAIL PROTECTED] 12/19/01 10:35AM >>> Hello, FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is the way to go. Thank you, Paul Sherman DBA voice - 781-501

Mabye OT: Was Re: Different clocks for different instances.

Speaking of the system clock, here's something interesting that I stumbled across a few years back... Background:  For those of you who may not know, the Julian calendar was abandoned by England, in favor of the Gregorian calendar, in 1752 because of date discrepancies.  To facilitate this, Septe

Synonyms causing a strange problem-Solved.

Greetings fellow DBAs: I just dealt with a problem I personally haven't run into before and thought that members of this list might be interested in reviewing: "User-A" owns all of a set of objects on Database "Primary-DB" including tables "Table-1" through "Table-100". "User-B" also

Problem with job

Title: Problem with job Hi! I created a new job in a database: variable jobno number; begin dbms_job.submit (:jobno, 'statspack.snap;', sysdate, 'trunc (sysdate,''HH24'') + trunc ((sysdate - trunc (sysdate, ''HH24''))*96+1)/96'); commit; end; The job was successfully

RE: Truncated table!!index still holding space??

alter index rebuild HTH Mark -Original Message- Sent: 19 December 2001 14:01 To: Multiple recipients of list ORACLE-L Hi Friends, I have two tables sized more than 2.3Gb has each index 700Mb, I truncated both tables!! I got space back of from tables, But indexes still showing its h

RE: hard disk configuration question

Oops... Hit the send button by mistake... As I was saying... I peeked at the HPUX doc for version 8.1.7... http://docs.oracle.com/a87032/0/unixdoc/product_0/a85346.pdf And it looks like 16K is you max... Just look up the appropriate doc for the versions you are working with to determine yo

RE: How to backup MTS database with RMAN

Title: How to backup MTS database with RMAN Helmut,   From the Oracle Documentation:   To use RMAN with an MTS database: Net8 configuration varies greatly from system to system. The following procedure illustrates only one method. This scenario assumes that the following net service name i

Re: Performance problem .... HELP :-(

Ian, What kind of a reorg was done? So the RATE_SCHEDULE_LINK_B table has about the same number of rows in both instances? The explain plans are the same. It looks like one just has more records to access. Both could be improved by changing the sql to be more selective. Mike >From: "Biddell

Re: Redo logs lost, old backups

Hi Maser, I am not sure this work or not. Actually my suggestion is call oracle support before you do anything. Just for your reference. 1) BACKUP the current situation with the database closed. The instructions here are destructive. You are STRONGLY advised to backup the cu

RE: SQL Loader Load Problem

That's the book I have. I have not found any other books totally for SQL*Loader. Ken -Original Message- Sent: Wednesday, December 19, 2001 8:16 AM To: Multiple recipients of list ORACLE-L Subject:RE: SQL Loader Load Problem Ken, Good to know that it worked. Not sure wh

sql loader-dates

Hi , In my data file i have dates in the format e.g. 12/19/2001, but when loader tries to insert this into the table , the table is expecting date in the format 19-DEC-01 so it rejects the data. What can i do to get around this? regards -- Please see the official ORACLE-L FAQ: http://www.oraf

RE: Help

Hello, FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is the way to go. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 18, 2001 10:40 PM To: Multi

RE: SQL Loader Load Problem

- Original Message - To: <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 11:30 AM > With Oracle 7.3.4 you could use this method: > > LOAD DATA > INFILE 'example.dat' > BADFILE 'example.bad' > insert > INTO TABLE emp > FIELDS TERMINATED BY ';' > (empno POSITION(*), > ename POSITI

brain F*rt question

List, I am having a big brain F*rt on a simple join query. I would like some input please. Two tables with common fields "retnbr and saledate" and other fields. I would like to select the saledate, sum of selected fields from table 1 and selected fields from table 2 for a particuler retnbr and g

TNS-00510: Internal limit restriction exceeded

I am getting these errors in my listener.log when trying to connect. Current connections are fine, it is only new connections getting the error. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapt

Re: Performance problem .... HELP :-(

Title: Performance problem HELP :-( Hi Ian,   take a careful look at fragmentation of their indexes and possible chained rows in the tables. Probably RATE_SCHEDULE_LINK_PK is a good start point Also the cardinality (estimated numbers of output rows for each step) may confuse you if their

Re:Palladium Consulting

They got me too. But I do have to admit that it was a nicely worded and non intrusive message. Dick Goulet Reply Separator Author: "Boivin; Patrice J" <[EMAIL PROTECTED]> Date: 12/19/2001 4:50 AM Did anyone get an e-mail from Palladium Consulting l

RE: SQL Loader Load Problem

page 121 'skipping fields you don't want to load' of g.gennick 'oracle sql*loader' book. -Original Message- Sent: Wednesday, December 19, 2001 9:16 AM To: Multiple recipients of list ORACLE-L Ken, Good to know that it worked. Not sure what books you referred to, but if you deal with S

RE: Performance problem .... HELP :-(

Did they rebuild their indexes after this "reorg"? It could be that they simply exported/imported the table without rebuilding the appropriate indexes? Just a thought.. Mark -Original Message- Ian Sent: 19 December 2001 12:55 To: Multiple recipients of list ORACLE-L Hi Stephane, Than

Re: unused blocks BELOW HWM - Thanks

Those stodgy old unix folks are much civilized than us anarchic DBA's. Jared On Wednesday 19 December 2001 00:15, Hallas John wrote: > I agree with your reasoning Dennis. I have long felt that one of the > problems with the list is that the original raiser of the question should > have some so

RE: Help

Actually, there is a bug fix to 8.1.7.1. You don't really need to go to 8.1.7.2 although I wouldn't necessarily say not to. -Original Message- Sent: Tuesday, December 18, 2001 7:40 PM To: Multiple recipients of list ORACLE-L If you are running 8.1.7.1, it has memory leak problem. Need

Converting from ASCII7 to UTF8

We are planning on converting our 240-Gig data warehouse (will be 8.1.7.2 on Sun Solaris 2.6) from character set ASCII7 to UTF8. Has anybody had any experience in doing this? If you have, what pitfalls, problems, etc. did you encounter? Anything that we need to watch out for? What about lo

Truncated table!!index still holding space??

Hi Friends, I have two tables sized more than 2.3Gb has each index 700Mb, I truncated both tables!! I got space back of from tables, But indexes still showing its holding space(I got from dba_segments), It looks weired!! Mine is oracle7.3 in AIX. Thanks Raghu. ___

ERROR RUNNING BATCJ JOBS

Title: How to backup MTS database with RMAN Hi, We are running batch jobs (SELECT/INSERT) since friday and it runs fine for first 3 days and now we start getting following errors: 1) ORA-01460 SQLSTATE 42000 2) function sequence error SQLSTATE HY010 3) value out of range error - SQLSTATE 2200

RE: recovery during refresh

You can SOMETIMES get away with copying online redo logs when in hot backup mode, IF there is no to little database activity during the hot backup step. BUT I would not do it as a general practice just for the reasons you are experiencing. CONTROL FILES AND ONLINE REDO LOG FILES SHOULD NOT BE

Forms60 Server as a service and mapped drives

I configured my Forms 6i service to run as an NT service using the Local Administrator account instead of SYSTEM, because we are using mapped drives to cram more pointers into forms60_path. I logged a TAR, because when the forms server is started as a process from the command line using the local

  1   2   >