10-24-2014
Script to create the SQLLDR control file from Oracle table.
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 DEPTNO
DEPT DNAME
DEPT LOC
EMP EMPNO
EMP ENAME
EMP SAL
..Etc..has more the few 100 tables.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Just wanted to know if there is a way to pass the table name as a parameter in the control file.
I have two tables...Table A and Table B.
LOAD DATA
append
INTO TABLE TABLE_B
FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"'
TRAILING NULLCOLS
Rather than hard coding... (1 Reply)
Discussion started by: madhunk
1 Replies
2. 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
3. HP-UX
Hi all,
I have to create table for each month inside a perl script.
tablename_monthnameyear.
megh_aug2008 for august 2008.
megh_sep2008 for september 2008.
just like the logfiles created on date basis.
thanks
megh (1 Reply)
Discussion started by: megh
1 Replies
4. Shell Programming and Scripting
Hey,
I want to create a table in bash, my db server is oracle. You can find my script below:
I am very confused. I tried to run this script many times without any luck. Please help! (6 Replies)
Discussion started by: radek
6 Replies
5. Shell Programming and Scripting
This is the sample sqlldr log:
------------------------------------------------------------------------------------------------------------
SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control... (13 Replies)
Discussion started by: aimy
13 Replies
6. Shell Programming and Scripting
Hi Team,
I need to create a control file with a pre-defined structure for a given table name. The table is in teradata.
Ex: Table Name: TBL1
Table structure:
create multiset table tbl1, no fallback,
no before journal,
no after journal,
checksum = default,
default mergeblockratio... (7 Replies)
Discussion started by: unankix
7 Replies
7. Shell Programming and Scripting
Hello Frens,
I am a newbie to shell scripting. I need a help on creating a for loop script (shell script) for removing files. I have a table called a_table with column name fil_name which contains all the files that need to be removed.
Thank you in advance (6 Replies)
Discussion started by: manisha_singh
6 Replies
8. Shell Programming and Scripting
I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by
modifying the script and show me how to execute it.
First Requirement:
I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
9. Shell Programming and Scripting
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT REDHAT
drop_table
DROP
TABLE(7) SQL Commands DROP TABLE(7)
NAME
DROP TABLE - remove a table
SYNOPSIS
DROP TABLE name [, ...] [ CASCADE | RESTRICT ]
INPUTS
name The name (optionally schema-qualified) of an existing table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if there are any dependent objects. This is the default.
OUTPUTS
DROP TABLE
The message returned if the command completes successfully.
ERROR: table "name" does not exist
If the specified table does not exist in the database.
DESCRIPTION
DROP TABLE removes tables from the database. Only its owner may destroy a table. A table may be emptied of rows, but not destroyed, by
using DELETE.
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is
referenced by a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove the foreign-key constraint, not
the other table itself.)
NOTES
Refer to CREATE TABLE and ALTER TABLE for information on how to create or modify tables.
USAGE
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
SQL92
SQL - Language Statements 2002-11-22 DROP TABLE(7)