Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
    Bookmark Topic Watch Topic
  • New Topic

Installation of Oracle 9ais

 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 254
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 27
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
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 ]
 
    Bookmark Topic Watch Topic
  • New Topic