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... (3 Replies)
Hi Guys,
I am looking to develop a SQL Loader script that would bascially allow the user to have a txt file (or such) as an input file containing .sql scripts procedures, triggers, bascially anything against a database that could then be run automatically.
Let me break it down a bit more,... (2 Replies)
Hi,
I am trying to load the records in a .txt file into the data base using SQL loader. I gave:
$ sqlldr user/pass@DB control=filename.ctl log =mylog.log
It throwed the following error:
SQL*Loader-297: Invalid syntax or bind variable in SQL string for column STATUS.
ORA-01756: quoted... (2 Replies)
Hi,
what is the ideal format of the file to load it into oracle table by using SQL*LOADER. The file contains six columns and the oracle table contains 15 columns. Is there any criteria that columns should be equal in no.?
Can anyone help me on this, i need to use this in my shell script?
... (2 Replies)
hi all
i am new to shell scripting.
i have 35 flat files delimited files that i have to load in to a table.
i was asked to create a shell script that loads the data into the table...
could you please help me if you have a script.
Also .. how to create logs files...does my sql... (3 Replies)
Hi Frnds,
I wanto load the data thats in data file with comma(,) delimited.
it throw this errors
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified
Plz look at my file... (3 Replies)
HI Experts,
We have a ksh file named ldr_empdelta.ksh and it is having the SQL*LOADER script as follows.
print "LOAD DATA" > $WEDB_GEN/ldrscan.ctl
print "INFILE '"$LED_SCAN"/delta/led_del.dat'" >> $WEDB_GEN/ldrparms.ctl
print "TRUNCATE" >> $WEDB_GEN/ldrscan.ctl
print "PRESERVE BLANKS" >>... (1 Reply)
All,
Below is the code written when sql loader loads the data:
$ORACLE_EXEC_PATH/sqlldr userid=$user_passwd control=$CNTR_FILES/invoice.ctl log=$LOG_FILES/$INVOICE_FILE.log bad=$ER
ROR_FILES/$INVOICE_FILE.bad data=$DATA_FILES/$INVOICE_FILE silent=FEEDBACK direct=false errors=50000
rc=$?... (1 Reply)
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 LINUX
dpkg-reconfigure
DPKG-RECONFIGURE(8) Debconf DPKG-RECONFIGURE(8)NAME
dpkg-reconfigure - reconfigure an already installed package
SYNOPSIS
dpkg-reconfigure [options] packages
DESCRIPTION
dpkg-reconfigure reconfigures packages after they have already been installed. Pass it the names of a package or packages to reconfigure.
It will ask configuration questions, much like when the package was first installed.
If you just want to see the current configuration of a package, see debconf-show(1) instead.
OPTIONS -ftype, --frontend=type
Select the frontend to use. The default frontend can be permanently changed by:
dpkg-reconfigure debconf
Note that if you normally have debconf set to use the noninteractive frontend, dpkg-reconfigure will use the dialog frontend instead,
so you actually get to reconfigure the package.
-pvalue, --priority=value
Specify the minimum priority of question that will be displayed. dpkg-reconfigure normally shows low priority questions no matter what
your default priority is. See debconf(7) for a list.
--default-priority
Use whatever the default priority of question is, instead of forcing the priority to low.
-a, --all
Reconfigure all installed packages that use debconf. Warning: this may take a long time.
-u, --unseen-only
By default, all questions are shown, even if they have already been answered. If this parameter is set though, only questions that have
not yet been seen will be asked.
--force
Force dpkg-reconfigure to reconfigure a package even if the package is in an inconsistent or broken state. Use with caution.
--no-reload
Prevent dpkg-reconfigure from reloading templates. Use with caution; this will prevent dpkg-reconfigure from repairing broken templates
databases. However, it may be useful in constrained environments where rewriting the templates database is expensive.
-h, --help
Display usage help.
SEE ALSO debconf(7)AUTHOR
Joey Hess <joeyh@debian.org>
2011-06-22 DPKG-RECONFIGURE(8)