I am new in unix..
I am running a sql loader script where I have to specify the data file path but the file name contains spaces in it
so giving error multiple arguments
I have tried it with "" and '' but does n't work the command is :
Last edited by Scott; 02-21-2011 at 12:47 PM..
Reason: Quote Tags -> Code Tags (also, easier to read)
Can someone send me a shell script to set all Oracle environment variable which is working.
I have the following script which works but not 100%. Please advice what you think is wrong.
if # Command executed from a terminal
then
ORACLE_SID=""
... (4 Replies)
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)
Hi,
Please let me know if anybody is having a solution handy for the below tasks...
It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task.
Task:
Check if the network drive exists
Check... (0 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 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)
Dear Folks,
I am facing an issue in getting a value of a variable.Let me explain the scenario.
I am having a list file say files.list in which I have mentioned
1 FILE1
2 FILE2
Then I am having an set_env.ksh in which I mentioned
FILE1=/clocal/data/user/userdata.txt... (4 Replies)
Hi,
Getting below error on executing the shell script which initiates sqlplus
How to set oracle enviornment variables in the shell script ?
With Regards (3 Replies)
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,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
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 REDHAT
xfs_logprint
xfs_logprint(8) System Manager's Manual xfs_logprint(8)NAME
xfs_logprint - print the log of an XFS filesystem
SYNOPSIS
xfs_logprint [ options ] device
DESCRIPTION
xfs_logprint prints the log of an XFS filesystem (see xfs(5)). The device argument is the pathname of the partition or logical volume con-
taining the filesystem. The device can be a regular file if the -f option is used. The contents of the filesystem remain undisturbed.
There are two major modes of operation in xfs_logprint.
One mode is better for filesystem operation debugging. It is called the transactional view and is enabled through the -t option. The
transactional view prints only the portion of the log that pertains to recovery. In other words, it prints out complete transactions
between the tail and the head. This view tries to display each transaction without regard to how they are split across log records.
The second mode starts printing out information from the beginning of the log. Some error blocks might print out in the beginning because
the last log record usually overlaps the oldest log record. A message is printed when the physical end of the log is reached and when the
logical end of the log is reached. A log record view is displayed one record at a time. Transactions that span log records may not be
decoded fully.
OPTIONS -b Extract and print buffer information. Only used in transactional view.
-c Attempt to continue when an error is detected.
-C filename
Copy the log from the filesystem to the file filename. The log itself is not printed.
-d Dump the log from front to end, printing where each log record is located on disk.
-D Do not decode anything; just print data.
-e Exit when an error is found in the log. Normally, xfs_logprint tries to continue and unwind from bad logs. However, sometimes it
just dies in bad ways. Using this option prevents core dumps.
-f Specifies that the filesystem image to be processed is stored in a regular file at device (see the mkfs.xfs(8)-d file option).
This might happen if an image copy of a filesystem has been made into an ordinary file with xfs_copy(8).
-l logdev
External log device. Only for those filesystems which use an external log.
-i Extract and print inode information. Only used in transactional view.
-q Extract and print quota information. Only used in transactional view.
-n Do not try and interpret log data; just interpret log header information.
-o Also print buffer data in hex. Normally, buffer data is just decoded, so better information can be printed.
-s start-block
Override any notion of where to start printing.
-t Print out the transactional view.
SEE ALSO mkfs.xfs(8), mount(8).
xfs_logprint(8)