Meaningless Drivel is fun!*
The moose likes Oracle/OAS and the fly likes Installation of Oracle 9ais Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply locked New topic
Author

Installation of Oracle 9ais

Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

Pinoccio!!!
Actually this isn't a question on 9ais, just a wake up call. There has been very little action here for a few days. Does everyone understand Oracle that well.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
Too busy at work these days! Or the questions were mostly on Java or Xml or javascript.
I hope you meant to write 9IAS.
Aha! one question just came up in my mind!!
Can we have multiple files listed in one control file for loading into multiple tables(sql*loader)? Any issues with that? What happens when default errors(50) reached in one of the files? Does it quit?
Best Regards
Beksy
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

Can we have multiple files listed in one control file for loading into multiple tables(sql*loader)?

well I haven't done multiple, but I know in Oracle 9i you can, plus you always can declare a "BadRecords" table that takes the records that don't get loaded.
It you have 50 default errors and that is what it is set to, yes it quits loading. Many first hand knowledge there.
Mark
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
I know that sqlldr quits when it reaches the default errors in the bad file. But my question was about the bad file when we have multiple files in one control file for multiple tables(if at all it is possible). Does it wait till it finishes all the files or quit as soon as any of the bad file gets the 50 records.
Thank you for your answer. We made the forum alive!!
Beksy
Atif Shah
Greenhorn

Joined: Jan 30, 2002
Posts: 27
hi i m new to ORA 9 as
i have ora9 1.2.0.0.0
just installed i could not understand how can i operate it
i wish to delpoy one simple JSP a
nd session bean in ORA 9as <for example ... can any one help>
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

Atif, I am creating a new thread for you question. This thread was only to get activity into this forum, so I doubt people will take the thread serious enough to get to the bottom and see you post, and I want you to get some responses back to help you.
You will find the new post here.
Mark
[ June 10, 2002: Message edited by: Mark Spritzler ]
 
jQuery in Action, 2nd edition
 
subject: Installation of Oracle 9ais