09-14-2018
You do not need to be on Oracle side to use sqlloader.
It's a client program, you have local (any) directory with data and oracle client installed (which contains sqlloader).
Then using credentials you upload the data to database thru network as you would use toad or sqlplus.
Have you looked up the ORA-01704 error and advice for it ?
Regards
Peasant.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies
2. UNIX for Advanced & Expert Users
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies
3. Programming
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Discussion started by: rramprasad
6 Replies
4. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
5. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
6. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
7. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
8. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
9. Shell Programming and Scripting
Hi can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database (2 Replies)
Discussion started by: LucyYani
2 Replies
10. Shell Programming and Scripting
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies
ris(8) System Manager's Manual ris(8)
Name
ris - remote installation services utility
Syntax
/etc/ris
Description
The utility performs remote installation services which install system software to a client machine through the TCP/IP local network. The
client machine can be a VAX or a RISC machine.
The server on which the remote installation services area is located can be either a VAX or a RISC machine.
The remote installation services utility uses the directory as a base. When you install the first product to the utility creates a remote
installation services area. The area is called either or
The area contains one or more ULTRIX software products. Each product contains the subsets of the kits that can be installed to clients on
a network. Clients registered for an area install software over the network to their processor.
The utility performs the following functions:
a - Add client
r - Remove client
s - Show products in remote installation environments
m - Modify client
i - Install software
You must use the utility interactively to set up a remote installation services area. After you have set up a remote installation services
area on the server, you can use the utility either interactively or from the command line to manage clients.
The directory also holds a subdirectory, This directory contains a database file, that you can use to manage multiple clients.
Examples
The example that follows invokes the utility interactively:
# /etc/ris
A menu appears from which you can select options to perform functions.
The examples that follow manage the client using the command line.
The syntax of the command to add a client follows:
/etc/ris -a <clientname> -h <Ethernet_address> -p path,product[,product]
The following command adds client and allows that client to install a product over the network:
# /etc/ris -a bergal -h 08-00-2B-03-05-8B -p ris0.mips,product_1
The syntax of the command to modify a client follows:
/etc/ris -a <clientname> [-h <Ethernet_address>] [-p <path,product,product>]
The following command modifies client and allows that client to install a product over the network:
# /etc/ris -m bergal -p ris0.mips,product_2
The syntax of the command to remove a client follows:
/etc/ris -r <clientname>
The following command removes client
# /etc/ris -r bergal
Files
See Also
setld(8)
Guide to the Remote Installation Services
Guide to Server Setup
ris(8)