04-23-2007
Bus error(coredump) while running SQL*Loader in HP Unix 11
Hi All,
I am getting coredump error, when I try to execute Oracle SQL*Loader from Shell script in Unix environment. But SQL*Loader from local machine runs fine with same database.
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Apr 23 05:23:47 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
sql.ksh[3]: 8438 Bus error(coredump)
Can you please guide me to resolve this error.
Thank you very much.
Regards,
Srinivas
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
i am getting the following error when i am using sql loader.
SQL*Loader: Release 8.1.7.4.0 - Production on Tue Apr 19 13:00:07 2005
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach
ORA-12535:... (4 Replies)
Discussion started by: sveera
4 Replies
2. UNIX for Dummies Questions & Answers
aix 5.3 ML1
system was functioing well, when suddenly telnet session hung and then I got the following message "Bus error(coredump)"
would appreciate if anyone would assist as to what to do next. (3 Replies)
Discussion started by: Student37
3 Replies
3. UNIX for Advanced & Expert Users
Hi,
I am using HP-UX.
While i try to run the Sqlplus command using the shel script in encounter the following error:
<shell script name>: some number Bus Error(coredump)
What may be the reason behind this.
I read few previous threads in this forum where i found some similar case. There it was... (2 Replies)
Discussion started by: Jayesh
2 Replies
4. UNIX for Dummies Questions & Answers
Hi Folks,
I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat... (2 Replies)
Discussion started by: jibbadiah
2 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I am getting bus error problem in SunOS. Can you please help me out in this regard.
Actually, my entire code till the last line has been executed. But after tht i am getting a bus error. Please help me.
Thanks in advance.
Charu. (4 Replies)
Discussion started by: charu
4 Replies
6. Shell Programming and Scripting
hi all,
how to handle sql loader errors in unix shell
??
thanks in advance
gemini (3 Replies)
Discussion started by: gemini106
3 Replies
7. HP-UX
Hi all,
I am quite weak in C but I need to get some work done. Hope someone can help me out. I keep getting this error when i try to run my C application in my HP-UX 10.20 machine.
Some code snippet:
Month(DBTime) =====This is a function which will return variable "CutOffTime" to be use... (5 Replies)
Discussion started by: Vision©
5 Replies
8. Shell Programming and Scripting
Hi ,
I have my log file something like this
(07/29/2009 00:02:24.467) 367518 (07/29/2009 00:02:26.214) 949384011
(07/29/2009 00:02:26.236) 367524 (07/29/2009 00:02:28.207) 949395117
(07/29/2009 00:02:28.240) 337710 (07/29/2009 00:02:30.621) 949400864
I am trying to insert the data... (3 Replies)
Discussion started by: rdhanek
3 Replies
9. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
10. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
LEARN ABOUT DEBIAN
dbix::class::schema::loader::dbi::writing
DBIx::Class::Schema::Loader::DBI::Writing(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBI::Writing(3pm)
NAME
DBIx::Class::Schema::Loader::DBI::Writing - Loader subclass writing guide for DBI
SYNOPSIS
package DBIx::Class::Schema::Loader::DBI::Foo;
# THIS IS JUST A TEMPLATE TO GET YOU STARTED.
use strict;
use warnings;
use base 'DBIx::Class::Schema::Loader::DBI';
use mro 'c3';
sub _table_uniq_info {
my ($self, $table) = @_;
# ... get UNIQUE info for $table somehow
# and return a data structure that looks like this:
return [
[ 'keyname' => [ 'colname' ] ],
[ 'keyname2' => [ 'col1name', 'col2name' ] ],
[ 'keyname3' => [ 'colname' ] ],
];
# Where the "keyname"'s are just unique identifiers, such as the
# name of the unique constraint, or the names of the columns involved
# concatenated if you wish.
}
sub _table_comment {
my ( $self, $table ) = @_;
return 'Comment';
}
sub _column_comment {
my ( $self, $table, $column_number ) = @_;
return 'Col. comment';
}
1;
DETAILS
The only required method for new subclasses is "_table_uniq_info", as there is not (yet) any standardized, DBD-agnostic way for obtaining
this information from DBI.
The base DBI Loader contains generic methods that *should* work for everything else in theory, although in practice some DBDs need to
override one or more of the other methods. The other methods one might likely want to override are: "_table_pk_info", "_table_fk_info",
"_tables_list" and "_extra_column_info". See the included DBD drivers for examples of these.
To import comments from the database you need to implement "_table_comment", "_column_comment"
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-06-08 DBIx::Class::Schema::Loader::DBI::Writing(3pm)