RE: SAME, WAFL and RAID

[Ken Janusz]

You make WAFL's with a WAFL iron.

Ken

 -Original Message-
Sent:   Tuesday, January 15, 2002 2:57 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: SAME, WAFL and RAID

May I make a suggestion?  It would be helpful if posters would expand
acronyms the first time they use them.  I, at least, have no idea what
WAFL is.  Thanks.


--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID 

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA Experiences with Oracle and RAID 0+1

[Ken Janusz]

Jon:

I would suggest "Oracle8i DBA Handbook" by Loney & Theriault.  Chapter 4
deals with the physical database layouts.  It starts with the ideal layout
on 22 disks and goes down to about 7 disks.  It's very good.

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN
 

 -Original Message-
Sent:   Monday, January 14, 2002 2:40 PM
To: Multiple recipients of list ORACLE-L
Subject:DBA Experiences with Oracle and RAID 0+1

We are in the process of setting up a SAN using RAID 0+1 for our database.
In our current environment, we are able to separate our tables, indexes,
rollback segments, and archive logs on different disks.  On the SAN we would
have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable
space (3 disks worth of space). 

Some white papers that I have read suggest attempting to separate the data,
indexes, and rollback segments on separate RAID volumes, and others simply
suggest that the performance boost of striping will supercede the separation
of these items.

Can anyone offer any comments or suggestions?

Jon Behnke
Applications Development Manager
Industrial Electric Wire & Cable
Phone (262) 957-1147  Fax (262) 957-1647 
[EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Behnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Need SQL*Loader Coding Help

[Ken Janusz]

I need some help coding this scenario.  I have multiple records coming in a
delimited flat file.  Some of the records are:

RegNumber
Cnum1
Cnum2
.
.
.
Cnum10

There can be data in 1 to 10 of these fields.

I need to load this into this table.
Trademark_Class_Data
  Registration_Number (FK)
  Class_Code_ID (FK)

An example of the code.
RegNumber - 65304
Cnum1 - 45
Cnum2 - 54
Cnum3 - 100

So, my question is how do I code this so that I create 3 records in this
table as?

Registration_Number Class_Code_ID
65304   45
65304   54
65304   100

I need to take data that is contained in 1 record and load it into 3
records.

Any help you can give me will be greatly appreciated.

Thanks,

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL*Loader Problem

[Ken Janusz]

Bill:

I also found that I have to specify the size of the column even if the data
field is being skipped using filler!

Ken

 -Original Message-
Sent:   Friday, January 11, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: SQL*Loader Problem

Where's what note 113211.1 on metalink says about this.  I hope it helps.

Problem Description
---

Using SQL*Loader to load data into a database table and rows fail to load
with the message:

Record X: Rejected - Error on table ""."", column "XX".
Field in data file exceeds maximum length

The data to be loaded will be longer than 255 characters and the database
column is set to larger than 255 characters.


Solution Description


In the control file specify the length of the column if the columns in the
database are longer than 255 characters.

eg
LOAD DATA
INFILE *
INTO TABLE "TEST"."TEST1"
APPEND
FIELDS TERMINATED BY ','
("COL1", "COL2" char(4000), "COL3")
BEGINDATA
333, data data data longer than 255 characters data data etc,this will work

Explanation
---

As a default, if the column length is not specified, it will default to a
maximum of 255 characters.  If the database column is longer than 255
characters and the data to be loaded exceeds 255 characters, then it exceeds
the maximum length.  Specifying the maximum length in the control file
overrides the default setting.


References
--

Oracle8 Server Utilities


Additional Search Words
---

sqlloader loader
.



Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 11, 2002 9:55 AM


> 8.1.7 on W2000
>
> I am loading data and keep getting an error.  The fields are text about
400+
> characters.  The column I am loading into is varchar2(4000).  I keep
getting
> rejects with this error: Field in data file exceeds maximum length.  Any
> ideas as to why this is happening?
>
> Thanks,
>
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient Systems, Inc.
> Minneapolis, MN
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Gentry
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL*Loader Problem

[Ken Janusz]

8.1.7 on W2000

I am loading data and keep getting an error.  The fields are text about 400+
characters.  The column I am loading into is varchar2(4000).  I keep getting
rejects with this error: Field in data file exceeds maximum length.  Any
ideas as to why this is happening?

Thanks,

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Loader Question

[Ken Janusz]

Ron:

 

That's
great, I'll give it a try.

 

Thanks,

Ken

 

-Original
Message-
From: Ron Rogers
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002
12:23 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: SQL Loader Question

 

Ken,

 You could create a batch file that references each par file
and then run the batch file.

ex:

file :testexp.bat contains the following lines;

exp login/passwd@server
parfile=location and name of parfile1

exp login/passwd@server
parfile=location and name of parfile2

etc.

then just execute the testexp.bat file.

Works good under Novell.

ROR mª¿ªm



>>> [EMAIL PROTECTED] 01/10/02 11:50AM >>>
I tested under 8.1.6 on NT and the reply is NO.
Checked also the new features for 9.0.1 and no mention of this.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From:    Deshpande, Kirti
[SMTP:[EMAIL PROTECTED]]
> Sent:    Thu, January 10, 2002 4:30 PM
> To:    Multiple recipients of list ORACLE-L
> Subject:    RE: SQL Loader Question
> 
> My guess is : No. 
> Can you run a quick test and let us know ?? 
> Thanks.
> - Kirti 
> 
> -Original Message-
> Sent: Wednesday, January 09, 2002 3:45 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 8.1.7 on W2000
> I would like to know if there is a way to group more than one parfile into
> one file?  I would like to run just one file verses a number of
parfiles.
> 
> Thanks,
> Ken Janusz, CPIM 
> Database Conversion Lead 
> Sufficient Systems, Inc. 
> Minneapolis, MN
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ken Janusz
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
(858) 538-5051
> San Diego, California    -- Public
Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
(858) 538-5051
> San Diego, California    -- Public
Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
San Diego, California    -- Public
Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: The OCP bar is being raised

[Ken Janusz]

Anyone CPIM?

Ken

 -Original Message-
Sent:   Thursday, January 10, 2002 12:23 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: The OCP bar is being raised

I'm OCSlave.

-Original Message-
Sent: Thursday, January 10, 2002 12:46 PM
To: Multiple recipients of list ORACLE-L


I know some Oracle employees that have OCD.

-Original Message-
Sent: Thursday, January 10, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L


How many people outhere that you know do actually have
OCM. Not ORACLE employees.

Just curious...

Regards,

Viktor









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: The OCP bar is being raised

[Ken Janusz]

I worked for Oracle for 14 months and then got laid off.  I got 7 weeks boot
camp for customizing & extending apps.  Then I also got another 6 weeks of
training.  They paid for all travel and I got my regular paycheck included.
It was a sweet deal.

Ken

 -Original Message-
Sent:   Thursday, January 10, 2002 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: The OCP bar is being raised

Oracle employees typically get Oracle training for free, esp. during times
when they are "idle" - whenever THAT happens.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:   Thursday, January 10, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: The OCP bar is being raised

How many people outhere that you know do actually have
OCM. Not ORACLE employees.

Just curious...

Regards,

Viktor
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8.1.7 Release 3 Patch for Solaris - Download Troubles

[Ken Janusz]

Kevin:

I had the same problem when I tried to download 9i zip files.  It turned out
to be a problem with the security setup on my laptop for IE.  

Ken

 -Original Message-
Sent:   Thursday, January 10, 2002 11:32 AM
To: Multiple recipients of list ORACLE-L
Subject:8.1.7 Release 3 Patch for Solaris - Download Troubles

Hey Guys.
  Just built my 8.1.7 solaris test server at work and need to patch it up to
Release 3.  Unfortunately, OTN keeps giving me "Page Not Found" when I go to
download it.

Does anyone know any alternate locations that these patches are available ??

Thanks

Kevin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: The OCP bar is being raised

[Ken Janusz]

Title: RE: The OCP bar is being raised








ENRON

 

-Original
Message-
From: orantdba
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002
9:36 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: The OCP bar is being
raised

 

Hmmm,

Imagine that,  a publicly traded company that it trying to make money, I
am shocked
dismayed, I don't believe I will be able to sleep tonight.  

Chris,  could you provide me with the list of companies that are not
trying to make money?
I want to make sure that I don't go to work for them, or learn their products.

John :-)

[EMAIL PROTECTED] wrote:



I'd say the
cost is being raised.  Look at the requirements for each.  You can't
just take the OCM exam.  No we would first have to get the OCA. 
Whether or not we need the entry level cert we have to have it.  Then, and
only then, can we take the OCP.  Then and only then, can we take the OCM
and that is after we take these REQUIRED classes from Oracle Ed.  So
someone the caliber of Steve Adams or Jared Still, has to spend money in a
class that they could probably teach from memory before they can get
certification and that is after getting 2 other certs that have no value to
them.  Call me a cynic, but to me, this is nothing but a money grab.

From the
website:

--To become
an Oracle Associate, you must pass the exams required
-- for the Oracle Associate level of your selected job role.
Typically, 
--two exams are required; the first one can be taken via the Internet,

--while subsequent exams must be taken in a proctored environment.
By 
--completing your Oracle Associate, you are half-way toward
achieving the
-- Oracle Certified Professional credential. 

 

--To become
an Oracle Certified Professional, you must pass all required exams 
--in your selected job role, including those at the Associate
level. 

 

--To become
an Oracle Certified Master, you must first be an Oracle 
--Certified Professional. Additionally, achieving your OCM
credential 
--requires attending two advanced level Oracle University courses
from 
--the list shown on this page as well as passing the OCM Practicum
exam. 

 

--Chris

 

-Original
Message-
From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] ] 
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: The OCP bar is being raised

 

Anyone care
to comment on the following, IMHO it's about time:

---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 
 
A recent *IDC report on IT Education and Training Services quoted
database
professionals and network engineers as the fastest-growing areas
of Professional
Certification. And in an October survey from *crn.com on
Certification, 58% of
respondents said that it is very difficult to find qualified
Oracle Certified
Professionals-Database Administrators. 

To meet this
demand, we have recently introduced two new levels of professional
achievement to DBAs (and soon to be released to Application and
Java Developers
worldwide): 

The Oracle
Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for
Oracle
Certified Professionals (OCP), that requires students to take a
practicum exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.html

for more information

IDC, IT
Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001

-
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City
Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    --
Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED]
(note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). 
You may
also send the HELP command for other information (like
subscribing).

 

RE: nls_date_format problem in sqlldr

[Ken Janusz]

Ruth:

Are you using a delimited flat file via SQL Loader?  Would the to_date
function do the trick?

My 0.03 Euro's worth,

Ken

 -Original Message-
Sent:   Thursday, January 10, 2002 7:25 AM
To: Multiple recipients of list ORACLE-L
Subject:nls_date_format problem in sqlldr

Good morning,

We are having a problem load a file containing dates in MON DD  format
into a database having and nls_date_format=MMDD.  Is there a way to do
an alter session command in the control file or the parameter file to that
we can load this data?

We have had the production database down for 4 days with various problems
and this is the last straw.

Thanks in advance,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Database jobs still hot

[Ken Janusz]

Where is your door?

Ken

 -Original Message-
Sent:   Wednesday, January 09, 2002 7:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Database jobs still hot

Ya, can you send them to my door?

-Original Message-
WILLIAMS
Sent: Wednesday, January 09, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L


To cheer up the listers that are searching for jobs, here is an article that
says database skills are still in the most demand. And, of course, Oracle is
specifically mentioned.

 http://www.cio.com/staffing/edit/010302_hot.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Loader Question

[Ken Janusz]

8.1.7 on W2000
I would like to know if there is a way to group more than one parfile into
one file?  I would like to run just one file verses a number of parfiles.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Tools that Reside on the Server Side of Oracle

[Ken Janusz]

I would like to know what are the tools / utilities that reside on the
Oracle server?  Server Mgr is one.  On the client side there is SQL Loader,
SQL*Plus, Exp/Imp. etc.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Reversing Unused Setting on a Column

[Ken Janusz]

Kirti:

Thanks, but I don't have access to Metalink.

Ken

 -Original Message-
Sent:   Tuesday, January 08, 2002 10:20 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Reversing Unused Setting on a Column

Yes, it is possible. But not supported by Oracle.
There is post by Mike Ault on Metalink Forum describing how to do this. Pl
search Metalink for it. BTW, his post is followed by Oracle's post reminding
the readers that it is a non supported operation (on data dictionary tables
owned by SYS). 

- Kirti

-Original Message-
Sent: Tuesday, January 08, 2002 9:36 AM
To: Multiple recipients of list ORACLE-L


I have heard that you can revere the UNUSED setting on a column.  Anyone
know how to do this?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reversing Unused Setting on a Column

[Ken Janusz]

I have heard that you can revere the UNUSED setting on a column.  Anyone
know how to do this?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Re[2]: Becoming a DBA questions

[Ken Janusz]

The Canadian gallon is not the same as the U.S. gallon.  The Canadian gallon
uses 5 qts. not 4.

My 0.03 Eureo's worth.
Ken

 -Original Message-
Sent:   Monday, January 07, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re[2]: Becoming a DBA questions

Monday, January 07, 2002, 9:15:21 PM, you wrote:
KS> I always find it funny when people do the conversions.  I don't know how
KS> many times I have to explain to people at work that $1 Canadian in
Canada
KS> has the same buying power as $1 American in the US.

I'm not convinced of that. Last time I visited Canada, gas
cost me more Canadian dollars per gallon that U.S. dollars
per gallon in the states. Ditto for coffee, pop, candy bars,
fast-food, etc. In many cases, portions were smaller. I'd
buy a large coffee at McDonalds in Canada and it'd be a lot
smaller than a U.S. large.

KS> Even funny is when I point out there was a time (and that is in my
lifetime)
KS> when Canadians flocked to the US to buy cause our dollar was worth more.
KS> They just won't believe me but I swear to god it's true.

I distinctly remember this. I don't remember the flocking
part, but I clearly remember a brief time back when I was a
teenager that the Canadian dollar was worth a few cents more
than ours. So now you've found at least one person who
believes.

Canada's my favorite vacation destination, btw. I had the
holidays off and tried to convince my daughter to go on a
rail/bus trip to Moosonee. I was really excited about the
idea, but Jenny wouldn't hear of it. She actually got mad at
me for even suggestion we travel farther north. So I gave up
on Moosonee for now, and I'm looking at maybe doing a
weekend rail trip to Hearst with my son.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Becoming a DBA questions

[Ken Janusz]

, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>  INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinard Xing
>  INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> --
> This transmission is for the intended addressee only and is
> confidential
> information. If you have received this transmission in error, please
> delete
> it and notify the sender. The contents of this e-mail are the opinion
> of the
> writer only and are not endorsed by the Mincom Group of companies
> unless
> expressly stated otherwise.
> 
=== message truncated ===


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Export Question

[Ken Janusz]

Does the Export utility export columns set to "unused"?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN'
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: XP Professional & 9i (YES IT IS A CERTIFIED COMBO ACCORDING T

[Ken Janusz]

If you purchase a Dell PC they will upgrade it to XP Prof. at no extra cost.
At least they did it for me.

Ken

 -Original Message-
Sent:   Thursday, January 03, 2002 8:05 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: XP Professional & 9i (YES IT IS A CERTIFIED COMBO
ACCORDING TO FETIDSTINK)

(Sorry to spoil everyone's fun)

I'll probably have to know this fairly soon, so I looked it 
up.

Oracle has certified the 9i client and 9i server for 
WindowsXP Pro (but not the Windows XP "Home" version).

>From MetaStink:

---excerpt---


General Notes For Oracle Server - Client On Microsoft Windows 
XP:

 Server Editions: 

   Windows XP has 2 editions/versions, Professional
   and Home. Oracle will ONLY certify on Professional. 

Oracle9.0.1 (9i) client: certified

Oracle9.0.1 (9i) Server - EE: certified, 

   (Oracle will ONLY certify on Professional.)

   additional notes:

[it says to search for patch sets, but I couldn't
 find any]

same for Server - Personal Edition
same for Server - Standard Edition/Workgroup Server

---end---

(Eric here again:)

I don't have time to look up the certification stuff for 
Developer/etc. right now, but will try to look it up tomorrow 
if anyone wants it that can't get into MetaStink.

You will however be required to write "Jared is a God" 1,000 
on your email chalkboard, or provide proof that you have used 
Pink Fuzzy Duct Tape in combination with a four post bed and 
whipped cream recently.

regards,
ep





On 30 Dec 2001 at 1:05, Oracle RDBMS Community Forum  wrote:

Date sent:  Sun, 30 Dec 2001 01:05:13 -0800
To: Multiple recipients of list ORACLE-L 
Forum)

> 
> --
> 
>  From: Ken Janusz <[EMAIL PROTECTED]>
>  Date: Sat, 29 Dec 2001 06:27:05 -0600
>  Subject: XP Professional & 9i
> 
> Will 9i run on XP Professional client?  And, no I am not interested in
> putting Linux on my home PC at this time.
> 

---end---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OTN Download Software Site

[Ken Janusz]

I have downloaded two of the 9i zip files from the OTN software site.  I
have one more to go and have not been able to get connected all day.  Anyone
know if there is a problem with the OTN site?

Thanks,
Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Problem Setting Up User

[Ken Janusz]

I am having a problem setting up a user on my DB (W2000 / 8.1.7).   

I have my self as user KENNETH and the new user is KIMV.

She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus
TABLE_NAME.

Here is what I have (I am grantee KENNETH and the user I am setting up is
KIMV):

GRANTEE GRANTED_ROLEDEFAULT_ROLE
KENNETH CONNECT YES
KENNETH DBA YES
KENNETH EXP_FULL_DATABASE   YES
KENNETH IMP_FULL_DATABASE   YES
KENNETH RESOURCEYES
KENNETH SELECT_CATALOG_ROLE YES
KIMVCONNECT NO
KIMVDB  NO
KIMVKIMVO   NO  
KIMVRESOURCEYES
KIMVO   CONNECT YES
KIMVO   RESOURCEYES

Also, Oracle will only allow me to have one granted role as YES at a time.
For example if I set DB to YES then RESOURCE goes to NO.

Your help will be greatly appreciated.

Thanks, 
Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OTN Download Hanging

[Ken Janusz]

I am trying to download the three .zip for 9i to my laptop (W2000).  The
download goes OK until it gets to 99%.  Then I look at Task Mgr. and it says
99% complete Not Responding.  Why is it hanging?  This has happened to me
three times in a row.

Thanks,
Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Problem Granting Roles

[Ken Janusz]

I granted myself roles via SYS.  I have another user on our server (W2000 /
8.1.7) and I have gone through the same process of granting the new user
roles via SYS.  However, when she connects to the DB she gets the message
that the objects don't exist.  The owner of the DB is me.  What am I doing
wrong?  Should I grant her roles from my user name or from SYS?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Import Problem

[Ken Janusz]

I have created the .bmp file for import to my DB.  All I want to do is
import that data.  Here is the imp script:

file=h:\kjanusz\sqlldr\log\nic13.dmp
log=h:\kjanusz\sqlldr\log\nic13imp.log
commit=N
ignore=Y
analyze=N
indexes=N
constraints=N
grants=N
rows=Y
destroy=N
tables=(*)  

And here is the error I am getting:

C:\>imp kenneth/kenjanzz@nic13 parfile='h:\kjanusz\sqlldr\ctl\nic13imp.dat'

Import: Release 8.1.7.0.0 - Production on Mon Dec 31 14:43:07 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
. importing KENNETH's objects into KENNETH
Import terminated successfully without warnings.

Yet when I select on the tables there is no data in them!  Any idea what the
problem is?  I haven't used Import before so I am new at this.  The Export
ran just fine.

Thanks, and have a Happy New Year,

Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Database Size

[Ken Janusz]

Where can I find the total size of my DB?  I have not found anything in the
DBA_ views or my documentation.

Thanks,
Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: XP Professional & 9i

[Ken Janusz]

Scott:

9i is for my home PC for educational purposed only.  I have gotten feedback
from a couple of folks who have installed the W2000 version on XP Prof.  and
have found that it works just fine.  

As far as Metalink goes.  I am using a DB for data conversion purposes only.
I am the only one who has access to the server and it has no application SW
hanging on it.  The client may join Metalink after they go live.  

Ken

 -Original Message-
Sent:   Saturday, December 29, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: XP Professional & 9i


I can't take it anymore!  The problem with Windows is IT ALLOWS STUPID
PEOPLE TO THINK THEY CAN USE COMPUTERS!!!  As wages are driven down by
idiots who don't really want to learn in the marketplace, its also cutting
into my money-making opportunities.


Thank you, I feel better now - the meds are kicking in.

Anyway if you absolutely must use Windows, from what a friend recently told
me, get Win2K if possible and stay off of XP.  Oh yeah - then install a
flavor of *nix on another partition and learn something about computers.

--S

"You want GUI?  I got yer GUI right here! Perl/TK Rulz!"



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, December 29, 2001 9:00 AM


> Now what would make you think that we would recommend that?  Oh, wait,
> cause its what advice is given to everyone;-)
>
> -Original Message-
> Sent: Saturday, December 29, 2001 4:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Will 9i run on XP Professional client?  And, no I am not interested in
> putting Linux on my home PC at this time.
>
> Thanks,
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient Systems, Inc.
> Minneapolis, MN
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: XP Professional & 9i

[Ken Janusz]

Oklahoma
Secretary of State.  The client
doesn't belong to Metalink either. 
They may after they go live.

 

Ken

 

-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 29, 2001
11:45 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: XP Professional &
9i

 

Ken,

 

See if your client doesn't have a CSI
number with which they'll let you register.  Just for grins and giggles,
can you divulge the conversion you're working on?  

 

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

 
Ken Janusz <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/29/2001 09:55 AM PST
Please respond to ORACLE-L

To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
bcc: 
Subject:
RE: XP Professional & 9i



Jared:

We are not on MetaStink because my company won't pay for it.
 It's their
problem not mine.

Ken

-Original Message-
Sent:Saturday, December 29, 2001 11:15 AM
To:Multiple recipients of list ORACLE-L
Subject:Re: XP Professional & 9i


That brings rise to the question "Why aren't you
a member of MetaStink?"

Have you purchased Oracle Support?  If so, you likely
have access to MetaLink.  If not, you need to.

You'll never be able to successfully implement an Oracle
based application on 9i without support.  You at least need
to have access to patches.

Jared

On Saturday 29 December 2001 06:25, Ken Janusz wrote:
> We are not a member of metastink.  I looked at OTN an it's only
certified
> up to W2000.  So, I was wondering if anyone knew if it is cert. for
XP
> Prof. or when it will be?
>
> Thanks,
> Ken
>
>  -Original Message-
> Sent:Saturday, December 29, 2001 7:50 AM
> To:Multiple recipients of list ORACLE-L
> Subject:Re: XP Professional & 9i
>
> Ken, go to metalstink and look for the certification matrix.
>
> joe
>
> Ken Janusz wrote:
> > Will 9i run on XP Professional client?  And, no I am not
interested in
> > putting Linux on my home PC at this time.
> >
> > Thanks,
> > Ken Janusz, CPIM
> > Database Conversion Lead
> > Sufficient Systems, Inc.
> > Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
 INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051
 FAX: (858) 538-5051
San Diego, California        -- Public Internet access /
Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
 INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051
 FAX: (858) 538-5051
San Diego, California        -- Public Internet access /
Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:
[EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX:
(858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
 To REMOVE
yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
you want to be removed from). You may also send the HELP command for other
information (like subscribing).

RE: XP Professional & 9i

[Ken Janusz]

Title: RE: XP Professional & 9i









John:

 

I work for
a very small company that does DB/application conversions for state
governments.  They will not spend
the money for Metalink.  I am the
only Oracle person in the company. 
So, my only source of Oracle information is documentation and the e-mail
lists.  I have found that a lot of
times the specific information I need is not in the documentation so the e-mail
lists are my last resort.  I am
very happy that these lists exist and all the help everyone has given me.

 

Thanks,

Ken

 

 

-Original
Message-
From: Hallas John
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001
3:00 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: XP Professional &
9i

 

I think it is our problem actually because
the majority of questions you ask could be answered quite easily by looking at
the manual or using Metalink.

Is your company just a one or 2 man band
or is it a reasonably sized company. If so I would have thought that having
Oracle support was a  necessity rather than a nice to have.

I once turned down a contract at a company
because they did not have 24 hour support and I was expected to do out of hours
support for which any call was made would be charged for. I and I am sure many
others have got into a situation where we are on our own/tired/stuck/confused
whatever and a call to support has been very helpful, not just for the answer
but more as someone to talk to, ensure that you are not about to do anyuhing
stupid (too late for me :-)). 

Knowadays there is a lot more on-line
resource available and this list is getting better all the time but I
personally think Metalink is invaluable both for resolving immediate problems
and digging deeper into areas of interest.

John 

-Original Message- 
From: Ken Janusz [mailto:[EMAIL PROTECTED]] 
Sent: 29 December 2001 17:55 
To: Multiple recipients of list ORACLE-L 
Subject: RE: XP Professional & 9i 

 

Jared: 

We are not on MetaStink because my company
won't pay for it.  It's their 
problem not mine. 

Ken 

 -Original Message- 
Sent:   Saturday, December 29, 2001 11:15 AM 
To: Multiple recipients of list ORACLE-L 
Subject:    Re: XP
Professional & 9i


 

That brings rise to the question "Why
aren't you 
a member of MetaStink?" 

Have you purchased Oracle Support? 
If so, you likely 
have access to MetaLink.  If not, you need to. 

You'll never be able to successfully
implement an Oracle 
based application on 9i without support.  You at least need 
to have access to patches. 

Jared 

On Saturday 29 December 2001 06:25, Ken
Janusz wrote: 
> We are not a member of metastink.  I looked at OTN an
it's only certified 
> up to W2000.  So, I was wondering if anyone knew if it
is cert. for XP 
> Prof. or when it will be? 
> 
> Thanks, 
> Ken

> 
>  -Original Message- 
> Sent: Saturday, December 29, 2001 7:50 AM 
> To:   Multiple recipients of list ORACLE-L 
> Subject:  Re: XP Professional
& 9i 
> 
> Ken, go to metalstink and look for the certification matrix. 
> 
> joe

> 
> Ken Janusz wrote: 
> > Will 9i run on XP Professional client?  And, no I
am not interested in 
> > putting Linux on my home PC at this time. 
> >

> > Thanks, 
> > Ken Janusz, CPIM 
> > Database Conversion Lead 
> > Sufficient Systems, Inc. 
> > Minneapolis, MN 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Jared Still 
  INET: [EMAIL PROTECTED] 

Fat City Network
Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California    --
Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from). 
You may 
also send the HELP command for other information (like
subscribing). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Ken Janusz 
  INET: [EMAIL PROTECTED] 

Fat City Network
Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California    --
Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from). 
You may 
also send the HELP command for other information (like
subscribing). 



=
This
electronic message contains information from the mmO2 plc Group 
which
may be privileged o

RE: XP Professional & 9i

[Ken Janusz]

Jared:

We are not on MetaStink because my company won't pay for it.  It's their
problem not mine.

Ken

 -Original Message-
Sent:   Saturday, December 29, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: XP Professional & 9i


That brings rise to the question "Why aren't you
a member of MetaStink?"

Have you purchased Oracle Support?  If so, you likely
have access to MetaLink.  If not, you need to.

You'll never be able to successfully implement an Oracle
based application on 9i without support.  You at least need
to have access to patches.

Jared

On Saturday 29 December 2001 06:25, Ken Janusz wrote:
> We are not a member of metastink.  I looked at OTN an it's only certified
> up to W2000.  So, I was wondering if anyone knew if it is cert. for XP
> Prof. or when it will be?
>
> Thanks,
> Ken
>
>  -Original Message-
> Sent: Saturday, December 29, 2001 7:50 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: XP Professional & 9i
>
> Ken, go to metalstink and look for the certification matrix.
>
> joe
>
> Ken Janusz wrote:
> > Will 9i run on XP Professional client?  And, no I am not interested in
> > putting Linux on my home PC at this time.
> >
> > Thanks,
> > Ken Janusz, CPIM
> > Database Conversion Lead
> > Sufficient Systems, Inc.
> > Minneapolis, MN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Shutdown Normal

[Ken Janusz]

Will shutdown normal allow me access the DB as SYS or SYSTEM while keeping
the regular users out?  Or, is there a better way of doing this?

Thanks,
Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: XP Professional & 9i

[Ken Janusz]

We are not a member of metastink.  I looked at OTN an it's only certified up
to W2000.  So, I was wondering if anyone knew if it is cert. for XP Prof. or
when it will be?

Thanks,
Ken

 -Original Message-
Sent:   Saturday, December 29, 2001 7:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: XP Professional & 9i

Ken, go to metalstink and look for the certification matrix.

joe


Ken Janusz wrote:

> Will 9i run on XP Professional client?  And, no I am not interested in
> putting Linux on my home PC at this time.
> 
> Thanks,
> Ken Janusz, CPIM 
> Database Conversion Lead 
> Sufficient Systems, Inc. 
> Minneapolis, MN
> 
> 


-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

XP Professional & 9i

[Ken Janusz]

Will 9i run on XP Professional client?  And, no I am not interested in
putting Linux on my home PC at this time.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Loader Parfile

[Ken Janusz]

Does anyone know how to put more than one control (.ctl) file in a single
parfile?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Exp / Imp Utility Questions

[Ken Janusz]

I'm doing a DB conversion to 8.1.7 on W2000.  I have converted the old
tables / data to the new application on my conversion server.  Now I have to
load it onto a test server at a different site.  I will be using tables=
parameter to a select group of tables / data.  I have not found the answers
to my questions in the documentation.

1. Can I use Exp / Imp to just move the data?  Or, does this utility
move the data and the table structures?

2. The conversion DB that I have only has the tables, PK's, FK's,
and indexes and no triggers, functions, cursors, etc. (they are created by
another script).  There is no application code attached to this DB.  The DB
I will be loading to is fully functional - all the PK's, FK's, triggers,
functions, et al.  Will loading the data from my conversion DB cause
problems with the test DB?

3. I know I will have to disable the FK's on the test DB.  But, what
about the triggers on the applicable tables?  Should they be disabled?

Anything else I need to know before I get rolling on this?

    Thanks,

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Loader Question

[Ken Janusz]

I have two control files.  Each file loads from a different flat file to a
series of Oracle (8.1.7) tables.  Is there a way I can place both of these
files together into one control file or on parfile?  

Thanks,
Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: XP vs. W2000

[Ken Janusz]

No magazine can be truly objective when they report on company products that
they receive advertising revenue from.  A negative report will mean lose of
revenue.  The newspaper industry found out this one the hard way with the
automobile industry.

Ken

 -Original Message-
Sent:   Thursday, December 27, 2001 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: XP vs. W2000

I wouldn't put my hopes on PC Magazine, I remember their "objective" reviews
of OS/2... They are not Consumer Report for the IT industry.

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égion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 


-Original Message-
From:   Larry Elkins [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, December 26, 2001 9:00 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: XP vs. W2000

As we are treading towards OT land, I've got a Dell PIII 750 with
512MB on
my desktop running WIN2K Pro. I just bought a laptop, Compaq
Presario PIII
1.0 Gig Chip with 512MB running XP Pro. I run 8i and 9i on both
machines.
The laptop is definitely snappier when running OEM 9i. With
comparably
configured laptops and desktops, you would expect the desktop to be
much
faster. So, even though my laptop has a 1 Ghz chip vs the 750 Mhz
chip on my
desktop, I expected the laptop to be slower. And it is when running
disk
intensive operations -- 4500 RPM on the laptop vs 7200 RPM and a
caching
controller on the desktop. But otherwise, the laptop with XP seems
to be a
tad faster, and maybe it's strictly due to the faster processor. It
would be
interesting to run some benchmarks against the same machine running
XP vs.
WIN2K -- I'm sure PC Magazine or some other group has already done
this.

And I haven't been on the Internet with the laptop since the XP
security
issues came to light. Something I need to address on the laptop.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Odd SQL Loader Problem

[Ken Janusz]

Could be, but how do I read it?

Ken

 -Original Message-
Sent:   Wednesday, December 26, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Odd SQL Loader Problem

Could you have a special character like cr or nl that is causing this
problem or indicating the end of record before reading all fields?

-Original Message-
Sent: Wednesday, December 26, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L


I am loading data into an Oracle table (8.1.7 on W2000 server).  I am
skipping fields (via filler) because I don't need to load them.  However, I
am getting an error on one of the input fields (being skipped) - field in
data file exceeds maximum length.  The record is a tilde "~" delimited flat
file. The field that is giving me the error is a lengthy character field - a
bunch of English verbiage.  There are no tildes in this lengthy string of
characters.

So, why would SQL Loader give me an error on a field I do not wish to load?


Thanks,
Ken



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Odd SQL Loader Problem

[Ken Janusz]

I am loading data into an Oracle table (8.1.7 on W2000 server).  I am
skipping fields (via filler) because I don't need to load them.  However, I
am getting an error on one of the input fields (being skipped) - field in
data file exceeds maximum length.  The record is a tilde "~" delimited flat
file. The field that is giving me the error is a lengthy character field - a
bunch of English verbiage.  There are no tildes in this lengthy string of
characters.

So, why would SQL Loader give me an error on a field I do not wish to load?


Thanks,
Ken



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

XP vs. W2000

[Ken Janusz]

This question is a little off the mark.  I will be ordering a new Dell PC
(8200) in the near future.  I would like to know which OS I should go with.
XP Professional or W2000?  Any suggestions?  Anyone have any experience with
XP Prof.?  Pluses / minuses?

Thanks,

Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Move DB to Another Schema

[Ken Janusz]

What about moving all the tables at one time (FULL=Y)?  I have about 150
just for the application.  And another bunch for the DB.  

 -Original Message-
Sent:   Friday, December 21, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Move DB to Another Schema

Ken.
   After creating the user, you can use export to move the tables one at a
time.  You will need to specify the owner of the table on the export (ie:
SYS.table name) and then on the import you will say FROMUSER=SYS  TOUSER=xxx
on the command line.  I would suggest examining the Utilities guide for
additional information.

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


 -Original Message-
Sent:   Friday, December 21, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Subject:Move DB to Another Schema

I can't find any details of this in any of my documentation.  I originally
created my DB as SYS.  I have setup a new user and need to move my DB /
Tables, etc. to the new schema.  How do I go about this?  Can I do it via
SQL Plus or do I need to do it via svrmgr?  Or, would it just be easier to
create a new DB (DDL SQL script) as the new user?

Thanks,
Ken Janusz
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Move DB to Another Schema

[Ken Janusz]

I can't find any details of this in any of my documentation.  I originally
created my DB as SYS.  I have setup a new user and need to move my DB /
Tables, etc. to the new schema.  How do I go about this?  Can I do it via
SQL Plus or do I need to do it via svrmgr?  Or, would it just be easier to
create a new DB (DDL SQL script) as the new user?

Thanks,
Ken Janusz
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Role Not Granted to User

[Ken Janusz]

I created the role KCJ and granted it create session, create user, alter
user.  Then I did alter user Kenneth default role KCJ.  Then I went to login
at sqlplus and get this error.

>From the DD views I get:
Grantee: SYS
Granted_role: KCJ
Admin_option: yes
Default_role: no
 
nic13> alter user KENNETH default role KCJ;
alter user KENNETH default role KCJ
*
ERROR at line 1:
ORA-01955: DEFAULT ROLE 'KCJ' not granted to user

What have I missed?

Thanks,

Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Where to I find roles assigned to user

[Ken Janusz]

Where do I find the roles assigned to a user?  I cannot find it in the DD
views.  

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-12988: cannot drop column

[Ken Janusz]

I have created a DB as SYS and added columns to some of the tables as SYS.
When I try to drop some of these columns I get this error.

ORA-12988: cannot drop column from table owned by SYS

How can I get around this problem?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Exp/Imp Utility

[Ken Janusz]

If I use Exp / Imp utility to just extract and load data into an existing
DB.  If there are more columns in the input record that in the DB table I am
importing to, will Imp generate an error?

Thanks,

Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, Inc. 
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sql loader-dates

[Ken Janusz]

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, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject: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.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Loader Load Problem

[Ken Janusz]

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 what books you referred to, but if you deal with SQL*Loader a lot,
then you may want to check out Jonathan Gennick's book titled 'Oracle
SQL*Loader : The Definitive Guide' by O'Reilly.  

 Regards.

- Kirti

-Original Message-
Sent: Wednesday, December 19, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L


Kirti:

Another person recommended this approach and it worked very nicely.  To bad
it's not in the book.

Thanks much,

Ken


 -Original Message-
Sent:   Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Load Problem

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Loader Load Problem

[Ken Janusz]

Kirti:

Another person recommended this approach and it worked very nicely.  To bad
it's not in the book.

Thanks much,

Ken


 -Original Message-
Sent:   Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Load Problem

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Loader Load Problem

[Ken Janusz]

I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Loader Load Problem

[Ken Janusz]

I have a data file of 11 fields to load into a table of 8 columns.  I only
have to load 3 of the input fields.  How do I handle the extra input fields?
I cannot use the DB table column for filler more than once.  Can I just
ignore the input fields I don't have to load?  I am using "trailing nulls"
and options direct=true.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: hard disk configuration question

[Ken Janusz]

This guy is full of it.  According to Loney & Theriault in Oracle8i DBA
Handbook ch. 4 - Physical DB Layouts.  The minimum recommended is 7 HD's.
The ideal is 22.   You are much better off with more smaller size drives
than with fewer larger sized drives.

My $0.02 worth,

Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, Inc.  
Minneapolis, MN


 -Original Message-
Sent:   Tuesday, December 18, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject:hard disk configuration question

We are in the process of buying new hardware, and our original configuration
called for 10 18 GB drives in a Hitachi disk array cabinet.  We are getting
some sales pressure to change this to 5 36 GB disks.  Now I was planning to
spread our DB out over as many mirrored pairs as possible, or maybe even
including one RAID1+0 array.  The sales folks at Hitachi are telling us that
with their new drive array technology, spreading our Data files over as many
disks as possible is not necessary. I am supposed to talk to one of their
engineers in an hour or so.

I am just wondering if there really is some magic bullet technology I have
missed out on, or is there sales guy full of hooey?


They are also pushing the presence of two internal(not in the drive cabinet)
drives as alleviating any space concerns.  I am wondering what I can use
those drives for.  I don't think I want to software mirror them, but maybe
Sun does this better than I think.  Without some kind of redundancy I am
reluctant to use these disks for any DB purposes.  Any thoughts here are
appreciated as well.

Thanks,

Steve McClure

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PL/SQL Cursor

[Ken Janusz]

Bind variables.  In Feuerstein's book in some of the code he shows the use
of the bind variable and in some he doesn't.  What is the rule on when to
use a bind variable?  The book doesn't discuss this.

Thanks,
Ken


 -Original Message-
Sent:   Monday, December 17, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: PL/SQL Cursor

It's all in the docs.  Read on DBMS_SQL package.
As for the error, you are getting, it is exactly, what it says: you didn't
bind variables (DBMS_SQL.BIND_VARIABLE(...)).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 17, 2001 4:26 PM


> I have written an explicit cursor - declare . . . begin . . . end.  When I
> try to run it I get this error:
>
> ORA-01008: not all variables bound
>
> I'm new to cursors, so I need some basic help.
>
> Thanks,
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient System, Inc.
> Minneapolis, MN
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PL/SQL Cursor

[Ken Janusz]

Raj:

Here is the code when I run it.  Any idea what the problem is?

Thanks, Ken

DECLARE
  cursor ok_sos_hist_reg_nbr_cur is
select tsh.tm_hist_reg_number,
   tdh.tm_hist_reg_number,
   trh.tm_hist_reg_number,
   d.tm_hist_reg_number
from   tm_status_history tsh,
   trademark_data_history tdh,
   trademark_registrant_history trh,
   document d
where  tsh.tm_hist_reg_number = tdh.tm_hist_reg_number
  and  tdh.tm_hist_reg_number = trh.tm_hist_reg_number
  and  trh.tm_hist_reg_number = d.tm_hist_reg_number
ORA-06550: line 14, column 0:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:

   . ( * @ % & - + ; / at for mod rem  and or
   group having intersect minus order start union where connect
   ||

BEGIN
  if not ok_sos_hist_reg_nbr_cur%ISOPEN
  then
open ok_sos_hist_reg_nbr_cur
ORA-06550: line 5, column 0:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:

   . ( % ; for


end if
end if
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :tsh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :tdh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :trh.tm_hist_reg_number
ORA-00900: invalid SQL statement


fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number
fetch ok_sos_hist_reg_nbr_cur into :d.tm_hist_reg_number
ORA-00900: invalid SQL statement


close ok_sos_hist_reg_nbr_cur
close ok_sos_hist_reg_nbr_cur
ORA-00900: invalid SQL statement


END
END
ORA-00900: invalid SQL statement


.
.
ORA-00900: invalid SQL statement





 -Original Message-
Sent:   Monday, December 17, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQL Cursor

 << File: ESPN_Disclaimer.txt >> This means that you are using some (bind)
variables but haven't supplied
values for them. Please post the code along with the open statement for the
cursor.

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: Any clod can have facts, but having an opinion is an art!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Change PCTINCREAE for SYSTEM Tablespace

[Ken Janusz]

I agree, I am leaving the SYSTEM tablespace alone.  Hands off.

Ken

 -Original Message-
Sent:   Tuesday, December 18, 2001 7:30 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Change PCTINCREAE for SYSTEM Tablespace

Kimberly,

I would agree with you if an experienced DBA makes the decision to change
the storage parameters, and they absolutely know what the benfits would be.

Generally speaking though, I think changing anything in the SYSTEM
tablespace is bad practice.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L


Actually, I would not ignore the storage parameters of the SYSTEM
tablespace.
There are legit reasons to change the pctincrease to 0.  If you leave it at
50 then SMON (or PMON can't remember at the moment) will try to coalesce the
tablespace every time it wakes up.  Its work it has to do that it really
does
not need to do.  Better off scheduling to happen at your time schedule.

-Original Message-
Thomas F
Sent: Monday, December 17, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L


Ken,

Do yourself a favor.  Ignore the SYSTEM tablespace storage params.  The ONLY
thing you should concern yourself in regard with the SYSTEM tablespace is if
the file needs to extend itself because it is too full.  All other storage
parameters are created by Oracle at database create time and should not be
changed.

For other tablespaces, you can change this parameter anytime after the
tablespace has been created.  It will not, however, change existing extents,
but will be used when new extents are allocated.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: h

PL/SQL Cursor

[Ken Janusz]

I have written an explicit cursor - declare . . . begin . . . end.  When I
try to run it I get this error:  

ORA-01008: not all variables bound

I'm new to cursors, so I need some basic help.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Change PCTINCREAE for SYSTEM Tablespace

[Ken Janusz]

I left the SYSTEM tablespace alone.  I did change the PCTINCREASE parameter
to 0 in all the tables in the applications.

Ken


 -Original Message-
Sent:   Monday, December 17, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Change PCTINCREAE for SYSTEM Tablespace

Ken:
  You can change the default PCTINCREASE for new objects in the SYSTEM
Tablespace, or you can change the PCTINCREASE for each object.  

   When the database is created the PCTINCREASE is set to 50% so that the
database would have sufficient room to allocate objects.  There is no other
way, that will allow you to keep your Oracle support in tact, to change this
value.

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


 -Original Message-
Sent:   Monday, December 17, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L
Subject:Change PCTINCREAE for SYSTEM Tablespace

Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Change PCTINCREAE for SYSTEM Tablespace

[Ken Janusz]

Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
without recreating the DB?  For some reason the person who created the DB I
am working on set PCTINCREASE to 50 (or didn't did not include this
parameter).I am using this DB for a data conversion so there is no
software connected to it and in turn no users on it.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Changing DB Table Parameters

[Ken Janusz]

I have some DB table parameters in my current DB - PCTINCREASE, sizing
related, etc.  Can this be done while the DB is up and running.  There is no
software connected to the DB so there are no users active on it.

Thanks,

Ken Janusz, CPIM
DB Conversion Lead
Sufficient Systems, Inc.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle Sequences

[Ken Janusz]

I have 12 tables that have the same named column in each.  I will be loading
(via sqlldr) data into these tables.  What I need to do is as each record is
loaded add a sequence number (currval) to each of these 12 tables.  The
sequence number will be the same for all 12 tables to tie them together.
When the next record is loaded I need to take the nextval in the sequence
and put it in all 12 tables.  And so on.

I have created the sequence object and it works on one table / column.
However, I cannot get the coding correct to do what I want.

Any and all suggestions are welcome.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL*Loader-417 Error

[Ken Janusz]

I've gone back to using the conventional path load.

Ken

 -Original Message-
Sent:   Friday, December 14, 2001 10:32 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL*Loader-417 Error

You should be able to say:
creation_date CONSTANT "2002-JAN-01",
If you database's default date format is '-MON-DD'

Caver

-Original Message-
Sent: Friday, December 14, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L


Rich:

The situation is that I have to default this date to 01/01/2002.  I tried
loading it using constant and it won't work.

Ken

 -Original Message-
Sent:   Thursday, December 13, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL*Loader-417 Error

Without the ability to try this, would "SYSDATE + 18" (or is it "19"?) work
in place of the "to_date"???

Wondering aloud...

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Thursday, December 13, 2001 16:05
To: Multiple recipients of list ORACLE-L


I am getting the following error for this line of code in my control file

Any ideas of how I can get around this?  When I try a conventional path load
I get a FK constraint error (not on this field).

creation_date "to_date('01/01/2002','dd/mm/')",

SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.


Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL*Loader-417 Error

[Ken Janusz]

Stephen:

I will probably stay with the conventional load and if I hid any FK
constraint problems I'll look into disabling the constraint.  I'm doing a DB
conversion into 8.1.7 with no application software connected to it.  The DB
is pretty much a duplicate of the production DB.

I am creating individual ctl load scripts for each table that I am loading.
I want to put them all into a single ctl control file so I don't have to run
them one at a time.  I would like to know if it is possible to have say one
script using direct path load and the other using conventional path load in
the same main ctl script?

Thanks, 

Ken

 -Original Message-
Sent:   Friday, December 14, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: SQL*Loader-417 Error

Ken, 

You can't do a lot of things to the data in a direct path load.  You
could modify your source data (awk, grep, sed, etc.) so you wouldn't
need to reformat the date field and then if there are no additional
problems, you will still have a problem with the FK that you are seeing
in the conventional load.  

Not knowing the FK error, I can't really point you towards a solution
there.  I would probably just stick with conventional since it is easier
than mucking around with your source data.  FK violations are good. They
mean you are not putting garbage into your database so you won't get
GIGO.

If you provide more info on your layout and the FK error I'm sure
someone will be able to help.
If you have any questions, please feel free to drop me a note.

Stephen Andert
Scottsdale, Arizona
>>> [EMAIL PROTECTED] 12/13/01 15:52 PM >>>
I am getting the following error for this line of code in my control
file

Any ideas of how I can get around this?  When I try a conventional path
load
I get a FK constraint error (not on this field).

creation_date "to_date('01/01/2002','dd/mm/')",

SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in
direct
path.


Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQLLDR and Direct Path Load

[Ken Janusz]

I want to put a number of ctl scripts together into one so I don't have to
run each script by itself.  Is it possible to have scripts for direct path
load and conventional path load in the same sqlldr script?  I don't think
so, but would like the opinion of others.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

URGENT!! SQLLDR: How do I load a constant date with Direct Path?

[Ken Janusz]

I need to load a constant date into a column (01/01/2002) and I need to use
direct path loading.  I tried:

creation_date "to_date('01/01/2002','dd/mm/')",

SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.

This works with conventional path load.  I have tried using constant and it
gives me an error.

How do I get around this?

Thanks,

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL*Loader-417 Error

[Ken Janusz]

I tried this and got the same error.  

creation_date "date (sysdate + 17 'mm/dd/')",

SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.

Any ideas as to how to get this to work?

Thanks,
Ken
 -Original Message-
Sent:   Thursday, December 13, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL*Loader-417 Error

Without the ability to try this, would "SYSDATE + 18" (or is it "19"?) work
in place of the "to_date"???

Wondering aloud...

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Thursday, December 13, 2001 16:05
To: Multiple recipients of list ORACLE-L


I am getting the following error for this line of code in my control file

Any ideas of how I can get around this?  When I try a conventional path load
I get a FK constraint error (not on this field).

creation_date "to_date('01/01/2002','dd/mm/')",

SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.


Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL*Loader-417 Error

[Ken Janusz]

Rich:

The situation is that I have to default this date to 01/01/2002.  I tried
loading it using constant and it won't work.

Ken

 -Original Message-
Sent:   Thursday, December 13, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL*Loader-417 Error

Without the ability to try this, would "SYSDATE + 18" (or is it "19"?) work
in place of the "to_date"???

Wondering aloud...

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Thursday, December 13, 2001 16:05
To: Multiple recipients of list ORACLE-L


I am getting the following error for this line of code in my control file

Any ideas of how I can get around this?  When I try a conventional path load
I get a FK constraint error (not on this field).

creation_date "to_date('01/01/2002','dd/mm/')",

SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.


Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL*Loader-417 Error

[Ken Janusz]

I am getting the following error for this line of code in my control file

Any ideas of how I can get around this?  When I try a conventional path load
I get a FK constraint error (not on this field).

creation_date "to_date('01/01/2002','dd/mm/')",

SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.


Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Recommenations for a DB conversion using SQL Loaderf

[Ken Janusz]

Thanks for the info.  I looked in Oracle8i Utilities in the SQL Loader
section and could not find anything about the 'exceptions into' clause.

Where should I look?

Thanks,
Ken


 -Original Message-
Sent:   Wednesday, December 12, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Recommenations for a DB conversion using SQL Loaderf



Ken,

That's one way to do it.  If your data is very large it will make the
loading much faster.

You can alleviate this by loading the tables in order of parents
first.  If you don't have an database diagram you can generate
this information from dba_constraints.

The easiest way is probably to disable the constraints, load
the data, then enable the constraints.

Be sure to thouroghly read the fine manual regarding constraints,
particularly the 'exceptions into' clause.

By redirecting exception rowids into another table you can
easily determine any rows that are causing a problem.

The way I do it if there is a lot of data and constraints to deal
with is to send exceptions to an exceptions table, move any
exception rows to another table, enable the constraint, and
then determine why the exception rows were excepted,
correct the problem and insert the row.

I haven't done this for awhile, and there may be new features
in 'ALTER TABLE ENABLE CONSTRAINT' that would change
this scenario somewhat, hence the RTFM.

HTH

Jared




 

Ken Janusz


fsys.com>cc:

Sent by: Subject: Recommenations for a
DB conversion using SQL Loaderf  
[EMAIL PROTECTED]

om

 

 

12/12/01 08:45

AM

Please respond

to ORACLE-L

 

 





I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?
Any and all suggestions are welcome.
Ken

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Recommenations for a DB conversion using SQL Loaderf

[Ken Janusz]

I am working on a one time DB conversion project for a state government
entity.  I have a DB (8.1.7 on W2000 server) setup without the application
SW that I am using to load the data into from flat files.  When I get this
data loaded I will then load it into the production tables at the client
site.  I will not be running any applications on this DB, it's for
conversion purposes only.  I am running into some constraint violation
problems since I am loading the data to each table one at a time.  Would it
be prudent to disable the constraints until I get all the data loaded?  
Any and all suggestions are welcome.
Ken

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Spooling to a flat file via SQL*Plus

[Ken Janusz]

Cherie:

If there are any commas in the date fields you will have problems with a
comma delimited file.  You may want to try "~" tilde delimited instead.

My $0.02,

Ken

 -Original Message-
Sent:   Wednesday, December 12, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject:Spooling to a flat file via SQL*Plus


I need to chang a column in an existing table from varchar2(2000) instead
to varchar2(255).
I'm to truncate any data that exists that is longer than 255.

I renamed the original table to old_table.   I created a new table with the
same definitions as
old_table except made the single column that was varchar2(2000) is now
varchar2(255).

I want to spool the data to a flat file in comma-delimited form.   I only
want to spool out 255
characters of the column in question.   Then I'll just load it back in
using SQL*Loader.

I haven't done this for a long time and I can't remember all the sql*plus
commands to
set up the output properly so that the lines can wrap, etc.   Also, I'm not
sure how to tell it
to only list 255 characters of the 2000 character column in the output
file.

I know I can spend some time looking this up in my docs but it's a terrible
day today with
a lot of fires burning in various directions.

I'd appreciate it if some kind sole could help me out with the commands to
spool this
out properly.


desc orig_cd_experience;
 Name  Null?Type
 - 

 KS_EXPERIENCEID   NOT NULL NUMBER(38)
 EXP_NOTES  VARCHAR2(2000)
 EXP_QA_STATE   VARCHAR2(100)
 TEMP_RNCHAR(1)
 EXP_REVIEW_NEEDED NOT NULL CHAR(1)


In everlasting gratitude,

Cherie


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

TEMP Tablespace Problem

[Ken Janusz]

Somehow I deleted the TEMP tablespace but not the datafile.  How do I go
about recreating this tablespace?

Thanks,
Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Why is this code not working?

[Ken Janusz]

When I run this code both columns I get no rows returned.  When I do a desc
on one of the tables I see both columns.  So, why am I not getting any data?

select table_name, column_name 
from dba_tab_columns
where 
(column_name = 'REGISTRATION_NUMBER' and
column_name = 'DOCUMENT_NUMBER')

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: truncate or drop

[Ken Janusz]

Ruth:

I would think you would want to truncate which deletes all the data and
resets the high water mark.  Dropping the tables?  I think this destroys the
table?  Then you have to recreate all the tables from a DDL SQL script.

Ken

 -Original Message-
Sent:   Monday, December 10, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:truncate or drop

Hi  Everyone!

I am trying to empty a database with some very large tables so I can import
it again.
Which is faster, truncating or dropping the tables?

Thanks in advance,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cannot Drop Column

[Ken Janusz]

I checked compatible in init.ora and it is set to 8.1.0.

Ken

 -Original Message-
Sent:   Sunday, December 09, 2001 11:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Cannot Drop Column


Did you check COMPATIBLE ? What is it set to ?


Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 12:05 PM


Oracle 8i
ALTER TABLE name DROP COLUMN name;
ROR mô¿ôm

>>> [EMAIL PROTECTED] 12/07/01 02:25PM >>>

Ken,

Just add the column with the correct name, and leave
the other one alone.

You could create a check constraint to make sure it isn't used.

Better yet, create a real account and don't use SYS or SYSTEM,
as that is never a good idea.

As you've already discovered, it really isn't all that convenient.  ;)

Jared




Ken Janusz

fsys.com>cc:
Sent by: Subject: RE: Cannot Drop Column
[EMAIL PROTECTED]
om


12/07/01 09:50
AM
Please respond
to ORACLE-L






Dave:

I am working on a database to do a DB conversion from IMS to 8.1.7.  It is
only being used to load the data for the conversion process.  No
application
software will be connected to it.  So, for convenience I am doing
everything
as SYS.  I am the only person using this DB on a dedicated W2000 server.  I
accidentally added this column by the wrong name, so I want to delete the
column so I can add the column with the correct name.  I would change the
name of the column but I have not found any syntax to do this.
Thanks,
Ken
 -Original Message-

Sent:   Friday, December 07, 2001 11:36 AM
To:Multiple recipients of list ORACLE-L


Ken,

I rarely log into any of my databases as SYS - too much mischief can be
made (and I'm just the fumble-fingered guy to make it).
There are very few columns owned by SYS.  Most of these are in tables
designed to support the database.  You need to be REAL careful.  Could be
that the table you're in is currently in use by virtue of the fact you're
logged in as SYS.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002




Ken Janusz


fsys.com>cc:

Sent by: Subject: Cannot Drop Column

[EMAIL PROTECTED]

om





12/07/2001

10:05 AM

Please respond

to ORACLE-L









8.1.7 logged in as SYS.

Will not let me drop a column because it belongs to SYS.

If I am logged in as SYS why can't I drop a column owned by SYS?

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also sen

Init.ora Compabible Setting

[Ken Janusz]

My init.ora compatible is set to 8.1.0.  Is this correct for 8.1.7?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cannot Drop Column

[Ken Janusz]

Is this in a DBA table?  If so, which one?

Thanks,
Ken 

 -Original Message-
Sent:   Sunday, December 09, 2001 11:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Cannot Drop Column


Did you check COMPATIBLE ? What is it set to ?


Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 12:05 PM


Oracle 8i
ALTER TABLE name DROP COLUMN name;
ROR mô¿ôm

>>> [EMAIL PROTECTED] 12/07/01 02:25PM >>>

Ken,

Just add the column with the correct name, and leave
the other one alone.

You could create a check constraint to make sure it isn't used.

Better yet, create a real account and don't use SYS or SYSTEM,
as that is never a good idea.

As you've already discovered, it really isn't all that convenient.  ;)

Jared




Ken Janusz

fsys.com>cc:
Sent by: Subject: RE: Cannot Drop Column
[EMAIL PROTECTED]
om


12/07/01 09:50
AM
Please respond
to ORACLE-L






Dave:

I am working on a database to do a DB conversion from IMS to 8.1.7.  It is
only being used to load the data for the conversion process.  No
application
software will be connected to it.  So, for convenience I am doing
everything
as SYS.  I am the only person using this DB on a dedicated W2000 server.  I
accidentally added this column by the wrong name, so I want to delete the
column so I can add the column with the correct name.  I would change the
name of the column but I have not found any syntax to do this.
Thanks,
Ken
 -Original Message-

Sent:   Friday, December 07, 2001 11:36 AM
To:Multiple recipients of list ORACLE-L


Ken,

I rarely log into any of my databases as SYS - too much mischief can be
made (and I'm just the fumble-fingered guy to make it).
There are very few columns owned by SYS.  Most of these are in tables
designed to support the database.  You need to be REAL careful.  Could be
that the table you're in is currently in use by virtue of the fact you're
logged in as SYS.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002




Ken Janusz


fsys.com>cc:

Sent by: Subject: Cannot Drop Column

[EMAIL PROTECTED]

om





12/07/2001

10:05 AM

Please respond

to ORACLE-L









8.1.7 logged in as SYS.

Will not let me drop a column because it belongs to SYS.

If I am logged in as SYS why can't I drop a column owned by SYS?

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also sen

RE: Cannot Drop Column

[Ken Janusz]

Ron:

This doesn't work.  I'm just ignoring the column and adding the correctly
named column.

Ken

 -Original Message-
Sent:   Friday, December 07, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Cannot Drop Column

Oracle 8i
ALTER TABLE name DROP COLUMN name;
ROR mô¿ôm

>>> [EMAIL PROTECTED] 12/07/01 02:25PM >>>

Ken,

Just add the column with the correct name, and leave
the other one alone.

You could create a check constraint to make sure it isn't used.

Better yet, create a real account and don't use SYS or SYSTEM,
as that is never a good idea.

As you've already discovered, it really isn't all that convenient.  ;)

Jared



 

Ken Janusz


fsys.com>cc:

Sent by: Subject: RE: Cannot Drop Column

[EMAIL PROTECTED]

om

 

 

12/07/01 09:50

AM

Please respond

to ORACLE-L

 

 





Dave:

I am working on a database to do a DB conversion from IMS to 8.1.7.  It is
only being used to load the data for the conversion process.  No
application
software will be connected to it.  So, for convenience I am doing
everything
as SYS.  I am the only person using this DB on a dedicated W2000 server.  I
accidentally added this column by the wrong name, so I want to delete the
column so I can add the column with the correct name.  I would change the
name of the column but I have not found any syntax to do this.
Thanks,
Ken
 -Original Message-

Sent:   Friday, December 07, 2001 11:36 AM
To:Multiple recipients of list ORACLE-L


Ken,

I rarely log into any of my databases as SYS - too much mischief can be
made (and I'm just the fumble-fingered guy to make it).
There are very few columns owned by SYS.  Most of these are in tables
designed to support the database.  You need to be REAL careful.  Could be
that the table you're in is currently in use by virtue of the fact you're
logged in as SYS.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002




Ken Janusz


fsys.com>cc:

Sent by: Subject: Cannot Drop Column

[EMAIL PROTECTED] 

om





12/07/2001

10:05 AM

Please respond

to ORACLE-L









8.1.7 logged in as SYS.

Will not let me drop a column because it belongs to SYS.

If I am logged in as SYS why can't I drop a column owned by SYS?

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author:
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (8

RE: Cannot Drop Column

[Ken Janusz]

Dave:

I am working on a database to do a DB conversion from IMS to 8.1.7.  It is
only being used to load the data for the conversion process.  No application
software will be connected to it.  So, for convenience I am doing everything
as SYS.  I am the only person using this DB on a dedicated W2000 server.  I
accidentally added this column by the wrong name, so I want to delete the
column so I can add the column with the correct name.  I would change the
name of the column but I have not found any syntax to do this.
Thanks,
Ken
 -Original Message-

Sent:   Friday, December 07, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Cannot Drop Column


Ken,

I rarely log into any of my databases as SYS - too much mischief can be
made (and I'm just the fumble-fingered guy to make it).
There are very few columns owned by SYS.  Most of these are in tables
designed to support the database.  You need to be REAL careful.  Could be
that the table you're in is currently in use by virtue of the fact you're
logged in as SYS.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


 

        Ken Janusz

  
fsys.com>cc:

Sent by: Subject: Cannot Drop Column

[EMAIL PROTECTED]

om

 

 

12/07/2001

10:05 AM

Please respond

to ORACLE-L

 

 





8.1.7 logged in as SYS.

Will not let me drop a column because it belongs to SYS.

If I am logged in as SYS why can't I drop a column owned by SYS?

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Cannot Drop Column

[Ken Janusz]

8.1.7 logged in as SYS.

Will not let me drop a column because it belongs to SYS.

If I am logged in as SYS why can't I drop a column owned by SYS?

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle DB Connection Problem

[Ken Janusz]

 8.1.7 on Dell W2000 server. 

When I try to login via sqlplus I get this: 

ORA-01034 Oracle not available 
ORA-27101 shared memory realm doesn't exist 

Then I get: 

Login: 
Password: 

And this error: 
ORA-12560 TNS: protocol adapter error. 

Any ideas as to what the problem is? 

Thanks, 
Ken Janusz 
Sufficient Systems, Inc. 

  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Generating a SQLLDR Sequence Number

[Ken Janusz]

Tom:

Ran into another problem.  I need to generate a sequence number for one of
the DB columns.  Here is the CTL code:

document_number sequence (max,80,1),

It runs but I keep getting the 80 that doubles for each record (80,
160, 320, etc.).  The book only shows the syntax but doesn't give an
example of how it works.

Any ideas?
Thanks,
Ken

 -Original Message-
Sent:   Tuesday, December 04, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Commit Point?

Ken

Did you look at the Sql*Loader log file?  
Maybe all your records were rejected and placed into the .bad file?  Does a
.bad file exist?  Sql*Loader does not really consider rejected records an
error - it just moves them there.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 03, 2001 4:33 PM
To: Multiple recipients of list ORACLE-L


I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.
 
-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Loader Commit Point?

[Ken Janusz]

I finally got it to work.  The book is a great help, but you still need the
old trial and error method.  

Thanks much for your help,

Ken

 -Original Message-
Sent:   Tuesday, December 04, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Commit Point?

Ken

Did you look at the Sql*Loader log file?  
Maybe all your records were rejected and placed into the .bad file?  Does a
.bad file exist?  Sql*Loader does not really consider rejected records an
error - it just moves them there.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, December 03, 2001 4:33 PM
To: Multiple recipients of list ORACLE-L


I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.
 
-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Loader Commit Point?

[Ken Janusz]

I am working on a control script that I have restricted to only loading 5
records as a test.  Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.
 
-

SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

--

When I do a select on this table I get no rows selected.

I don't get an error message from SQL Loader.

So any ideas as to what the problem is?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Loader Input File Situation

[Ken Janusz]

8.1.7

I am loading an input file to a single DB table.  The input file is
different than the table I'm loading and contains fields I don't need to
load.  I do not want to load some of the input fields.  The input file has
11 cols. and I need to ignore 5 of them.  The DB table has 15 cols and I
know how to ignore them with the filler clause.  The input file is a
delimited flat file.  How do I tell SQL*Loader not to load various input
fields?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Deleting files on w2k

[Ken Janusz]

Title: RE: Deleting files on w2k









My
daughter works for Target in Minneapolis. 
They outsourced some of their support to IBM.  Guess who the IBM people come to when they can't solve a
problem?  

 

Ken

 

-Original
Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001
9:15 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Deleting files on w2k

 

You are!  The
problem is, by going with an os other than windoze of some sort, I am almost
guaranteed that the production hardware and software support will be outsourced
& moved to Denver, CO to IBM's datacenter there.  This stupid company
believes in paying ibm to do everything they are afraid to or can't do.  I
think I should go work for IBM.  The dev servers I will still have. 

I"ll have a linux
server at home yet :)


-Original
Message- 
From:   Kimberly
Smith [SMTP:[EMAIL PROTECTED]] 
Sent:   Monday,
December 03, 2001 9:51 AM 
To: Multiple
recipients of list ORACLE-L 
Subject:    RE:
Deleting files on w2k


Go with Linux.  That
way you could use your same servers:-)  Ain't I so useful!  HA 

-Original
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu,
Lisa
Sent: Monday, December 03, 2001
6:20 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Deleting files on w2k

Believe me, I wish...
if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000
we'd be there...  I'm stuck with this one.  

-Original
Message-
From:   Kimberly
Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Friday,
November 30, 2001 4:25 PM
To: Multiple
recipients of list ORACLE-L
Subject:    RE:
Deleting files on w2k 

Um, port it to Unix 

-Original
Message-
From: [EMAIL PROTECTED] [ ]On Behalf Of Koivu,
Lisa
Sent: Friday, November 30, 2001
12:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: Deleting files on w2k

I'm trying to test out
backup and recovery on w2k.  However, I can't remove or rename a file
while the database is running!  It says "file in use".  

Am I missing something
or is there a way to force this?  

Thanks 

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117 

RE: stripes, partitions, and spindles

[Ken Janusz]

Ruth:

Get a copy of the Oracle8i DBA Handbook by Loney & Theriault.  Chapter 4's
topic is Physical Database Layouts.  It goes from 22 disks down to 7.

Hope this helps,

Ken 

 -Original Message-
Sent:   Friday, November 30, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L
Subject:stripes,  partitions, and spindles

Good morning all,

We have purchased new IBM AIX boxes and the guy whole sold them to us is
here puting them together. ( He used to work for IBM.)  The question rises
again, do I put my tablespaces on separate spindles, e.g. Data on one, Data2
(big extents) on 2, Index1, Index2 all on separate spindles or do I stipe
everything.  We are planning to partition or largest table (bottleneck)
after the duhvelopers figure out how to do it.

We will have plenty of spindles for system,redo, etc.

I need some good arguments for each.  I don't really think the ex-IBMer
should have the final word.

We have a three-tier application  which all employees use and nightly batch
processing.   We have two databases which run separately during the day and
communicat with each other at night through db_links.   Everything runs
through this one huge table (it is like a general ledger).

The boss says she has run a stiped Oracle database in the past but doesn't
really know if this is the best.

I will be eternally grateful for all info.

TIA,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Errors running catdbsyn.sql

[Ken Janusz]

When I run catdbsyn.sql I get these errors


drop synonym DBA_CATALOG
ORA-01434: private synonym to be dropped does not exist

create synonym DBA_CATALOG for SYS.DBA_CATALOG
ORA-01471: cannot create a synonym with same name as object

Why is this and what can I do about it?

Thanks,

Ken
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SYS vs SYSTEM

[Ken Janusz]

8.1.7 on W2000

select owner, table_name, tablespace_name from dba_all_tables;


When I log into sqlplus as SYS is runs.

When I log into sqlplus as SYSTEM I get the error table or view does not
exit.

What is happening here and how do I fix it?

Thanks,

Ken 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unable to run catalog.sql

[Ken Janusz]

Kurt:

Thanks I'll give this a try.

Ken

 -Original Message-
Sent:   Wednesday, November 28, 2001 10:06 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Unable to run catalog.sql

  Ken,
I went out to metalink and did a search on SP2-0310; this is the result.
I hope
it proves useful.
 
Kurt Wiegand
IBM Global Services
Cable & Wireless Communications
703 760-3619
 


Bookmark Fixed font  Go to End 
 
Doc ID:  Note:121371.1 
Type:  PROBLEM 
Status:  REVIEWED 
 Content Type:  TEXT/PLAIN 
Creation Date:  04-OCT-2000 
Last Revision Date:  02-FEB-2001 
 
 
*
This article is being delivered in Draft form and may contain
errors.  Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
*
 
Problem Description
---
 
You have created a SQL script and saved it to a directory on your
PC hard drive (for example c:\script).  You are able to execute this
script in SQL*Plus by entering the following command:
 
SQL>@C:\script\myscript.sql
 
However, when you try to open the script file in the SQL*Plus session, 
via Top Menu Bar --> File --> Open --> you receive an error:
 
SP2-0310: unable to open file "c:\script\myscript.sql"
 

Solution Description

 
This error can be eliminated by doing one of the following 
workarounds:
 
1.  Within the SQL*Plus window, enter the following command:
 
SQL> set editfile C:\script (directory where scripts are saved)
 
NOTE: This will allow you to open the myscript.sql file without encountering
any errors, but the setting will only be retained for the current session.
If
you would like to make this a permanent change, add the above command to the
login.sql file on your PC.
 
2.  Update the Windows Registry to add, or edit, the SQLPATH variable:
 
On Windows PC, go to Start --> Run --> Regedit --> HKEY_LOCAL_MACHINE -->  
Software ---> Oracle ---> desired Home (could be HOME0, HOME1, etc.) and 
add/modify new string value for SQLPATH.  Once the string is added, you can
edit it to specify the directory where your SQL scripts are stored.
You can have multiple directories, but each directory must be separated by
a semicolon (;).
 
Explanation
---
 
The SP2-0310 is an abnormal error condition.  In a default Windows
installation,
this error should not occur when trying to open a file in the manner
described.
By setting the editfile or SQLPATH, the errors is resolved.
 
The SQLPATH variable is used as the search path when SQL*Plus executes
scripts. 
By default, SQL*Plus, will first search in the Oracle_Home\bin directory 
and then any directories specified in the SQLPATH variable.
 

References
--
 
Other Related documents or causes for this error:
 
Bug 883193, SP2-310 CANNOT SPECIFY A DIRECTORY WITH SPACES IN BETWEEN
Bug 935869, SLDEXT FUNCTION DOES NOT RECOGNIZE "?" AS A ORACLE
Note 105052.1, Does SQL*Plus not recognize files in directories with 
   spaces in their names?
 

Additional Search Words
---
 
path,plus80, script, plus81, SP2
.
 
 
 


 
 Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal
Notices and Terms of Use.  
 
 

-Original Message-
Sent: Wednesday, November 28, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L



I am connected as sys.

 

Ken

 

-Original Message-
Sent: Wednesday, November 28, 2001 4:05 AM
To: Multiple recipients of list ORACLE-L

 

the catalog.sql Must be run when connected to SYS or INTERNAL. 

Is it true for ur case? 
Nirmal., 

-Original Message- 
Sent:   Tuesday, November 27, 2001 10:00 PM 
To: Multiple recipients of list ORACLE-L 

I have tried to run catalog.sql from the sql*plus command line and keep 
getting this error. 
sp2-0310 unable to open file "catalog.sql".  I've use the full path name 
with the same results.  
catalog.sql is on my PC and the database is located on a server.  
I have run other commands from my client machine with no problems.  

What appears to be the problem? 

TIA 

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>  
-- 
Author: Ken Janusz 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name o

For You Telnet Experts

[Ken Janusz]

I cannot get svrmgrl to run at the Command Prompt or sql*plus prompt.  I
keep getting an error - unrecognized command.  When I try to get Telnet to
connect to the server it won't.  Could this be the problem of why svrmgrl
won't work?  I need svrmgrl to run my "cat" scripts.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unable to run catalog.sql

[Ken Janusz]

Title: RE: Unable to run catalog.sql









I am
connected as sys.

 

Ken

 

-Original
Message-
From: Nirmal Kumar Muthu Kumaran
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001
4:05 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Unable to run
catalog.sql

 

the catalog.sql Must be run when connected to SYS or INTERNAL. 

Is it true for
ur case? 
Nirmal., 

-Original
Message- 
From:   Ken
Janusz [SMTP:[EMAIL PROTECTED]] 
Sent:   Tuesday,
November 27, 2001 10:00 PM 
To: Multiple
recipients of list ORACLE-L 
Subject:    Unable
to run catalog.sql 

I have tried to run
catalog.sql from the sql*plus command line and keep 
getting this error. 
sp2-0310 unable to open file
"catalog.sql".  I've use the full path name 
with the same results.  
catalog.sql is on my PC and the database is
located on a server.  
I have run other commands from my client machine
with no problems.  

What appears to be the
problem? 

TIA 

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Ken Janusz 
  INET: [EMAIL PROTECTED] 

Fat City Network
Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego,
California    -- Public Internet access
/ Mailing Lists 
 
To REMOVE yourself from this mailing list, send
an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in 
the message BODY, include a line containing:
UNSUB ORACLE-L 
(or the name of mailing list you want to be
removed from).  You may 
also send the HELP command for other information
(like subscribing). 

RE: Problem Starting SQL Loader

[Ken Janusz]

It appears to be running from the command prompt.

Ken

 -Original Message-
Sent:   Tuesday, November 27, 2001 4:35 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Problem Starting SQL Loader

Hi Ken,

SQlldr is not a sqlplus command.  It will need to be run from the OS 
like sqlplus.

Good Luck

[EMAIL PROTECTED] wrote:

>I am in sql*plus (8.1.7) logged in as sys.  When I try running "sqlldr" at
>the command prompt I get this error:
>
>SP2-0042:  unknown command "sqlldr" - rest of line ignored.
>
>I'm calling it from my client PC and the DB is located on a separate
server.
>
>How do I get this to work?
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Hough
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Problem Starting SQL Loader

[Ken Janusz]

I tried it from the command prompt and got in.

Thanks,
Ken

 -Original Message-
Sent:   Tuesday, November 27, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Problem Starting SQL Loader

sqlldr is not a sqlplus command - it needs to be called
from the OS command line.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 5:00 PM


> I am in sql*plus (8.1.7) logged in as sys.  When I try running "sqlldr" at
> the command prompt I get this error:
>
> SP2-0042:  unknown command "sqlldr" - rest of line ignored.
>
> I'm calling it from my client PC and the DB is located on a separate
server.
>
> How do I get this to work?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Problem Starting SQL Loader

[Ken Janusz]

This appears to be working.
Thanks,

Ken

 -Original Message-
Sent:   Tuesday, November 27, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Problem Starting SQL Loader



Ken,

Sqlldr is a stanalone utility, it doesn't run from inside SQL*Plus, it runs
from the
OS  command line.

Take a look at the utilities manual for the docs on sqlldr.

Jared




 

        Ken Janusz


fsys.com>cc:

Sent by: Subject: Problem Starting SQL
Loader   
[EMAIL PROTECTED]

om

 

 

11/27/01 02:00

PM

Please respond

to ORACLE-L

 

 





I am in sql*plus (8.1.7) logged in as sys.  When I try running "sqlldr" at
the command prompt I get this error:

SP2-0042:  unknown command "sqlldr" - rest of line ignored.

I'm calling it from my client PC and the DB is located on a separate
server.

How do I get this to work?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Problem Starting SQL Loader

[Ken Janusz]

I am in sql*plus (8.1.7) logged in as sys.  When I try running "sqlldr" at
the command prompt I get this error:

SP2-0042:  unknown command "sqlldr" - rest of line ignored.

I'm calling it from my client PC and the DB is located on a separate server.

How do I get this to work?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Unable to run catalog.sql

[Ken Janusz]

I have tried to run catalog.sql from the sql*plus command line and keep
getting this error.
sp2-0310 unable to open file "catalog.sql".  I've use the full path name
with the same results.  
catalog.sql is on my PC and the database is located on a server.  
I have run other commands from my client machine with no problems.  

What appears to be the problem?

TIA

Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Altering Indexes

[Ken Janusz]

Dennis:

Thanks for the advice.  Fortunately I am doing a DB conversion from IMS /
Lotus Notes to 8.1.7.  This is being done on a dedicated server which only I
have access to and there is no application software connected to it.  When I
finish the data conversion the data will be exported (for want of a better
word) to the production DB where it will be tested.  So, taking time do
"something" is not a problem. Currently the only data I have on the system
is a small lookup table.  So, the process would probably go rather quickly.

Ken

 -Original Message-
Sent:   Tuesday, November 27, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Altering Indexes

Ken - No, there isn't a magic single command. Moving the indexes, even with
alter index, cause a lot of work for Oracle, and can consume quite a bit of
time. As the typical cautious production DBA, I do not like to start a
really large monolithic process that might make my system unavailable to the
users for an unknown period of time. I would recommend that you use SQL to
create a script to alter the indexes. This will allow you to Pareto's rule
to do the many small indexes first, then work up to the larger indexes that
use increasing amounts of time. Also, I would recommend considering several
index tablespaces, maybe even moving the largest tables to their own
tablespace first.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, November 27, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L


I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Altering Indexes

[Ken Janusz]

I have this large DB (approx. 250 tables) that has the tables and indexes in
the same tablespace (not my design).  Is there a way I can move all of the
indexes to a separate tablespace en-mass?  I know I can move them one at a
time with the alter index command, but that would be rather time consuming.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Fixing a DB

[Ken Janusz]

Looks good.  Does "fol" mean following?

Thanks,

Ken

 -Original Message-
Sent:   Wednesday, November 21, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Fixing a DB

Sorry forgot the command in my earlier email

To recap, here are the steps

1. create the new tablespace
2. For all indexes that need to be moved, run the fol command
  alter index . rebuild online tablespace 
;


>From: Ken Janusz <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Fixing a DB
>Date: Wed, 21 Nov 2001 05:25:34 -0800
>
>We have a DB that is currently in more-or-less development mode for a state
>government client.  The DB has been created (11,300 lines of SQL*Plus code)
>with the tables and indexes stored in the permanent tablespace
>(SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
>currently holds test data.  I think the process to correct this would be:
>
>1. Determine the size, etc. of the INDEX tablespace, write the script and
>then run it to create the tablespace.
>
>2. Go through the DDL SQL script for OKSOS (state gov. office name
>abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
>tablespace name.
>
>3. Then run the DDL SQL script to create the new DB.
>
>4. Then do and Export of the data from the old DB and Import it into the 
>new
>DB.
>
>5. Then I think I have to regenerate your indexes.  I'm not clear on this
>point. Will the Export/Import process may take care of this?
>
>Is there anything I have missed?  I'm sure there is.
>
>Thanks,
>
>Ken Janusz, CPIM
>Database Conversion Lead
>Sufficient System, Inc.
>Minneapolis, MN
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ken Janusz
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
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: Sunny Verghese
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Disabling Constraints

[Ken Janusz]

Ruth:

Thanks, I found this to work also.

ALTER TABLE '"TABLE_NAME"
DISABLE CONSTRAINGT "CONSTRAINT_NAME";

Ken

 -Original Message-
Sent:   Tuesday, November 27, 2001 7:00 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Disabling Constraints

Here is a script which generates all of the 'alter table' statements to drop
the referential constrains.  Spool if or cut and paste and you should be all
set.

select 'alter table schema.'||table_name||' disable constraint
'||constraint_name||';'
from dba_constraints
where  CONSTRAINT_TYPE in ('R')
and owner='SCHEMA';

HTH,
Ruth

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 5:31 PM


> I need to disable some constraints to load table data for my DB
conversion.
> I cannot find the syntax to do this.  I think it should be ALTER TABLE
> something.
>
> Thanks,
>
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient System, Inc.
> Minneapolis, MN
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).