Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Hi All
I am new to unix.
I need a shell script to load a datafile in to oracle.
I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table.
Control file : PAY0001.ctl
Datafile : mon_grs_det.dat
log file :... (3 Replies)
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
I have a flat file with records like
Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer
The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters
These are sample... (1 Reply)
Hi,
I need to extract a oracle staging table to a flat file thru unix batch process.We are expecting more than 4million records in the table.I know I can do it using "UTL_FILE" .But,since "UTL_FILE" takes a lot of time I am looking for better options.Can any body suggest some better options?
... (3 Replies)
Hi ,
I have a scenario, i have a directory where i receive around 14-15 files at a interval of 20-40 min not fixed, i want to write a unix scripts which invoke sqlldr command to load files into oracle automatically as soon as the file hit the directory.
Any help will be appreciated.
... (4 Replies)
Hi, I am very new to UNIX environment. And I am stuck in this problem.
In my Unix server, I have a file called "tablelist.txt" which gives me a list of the tables in my oracle database like shown below.
bmp.table1
bmp.table2
bmp.table3
:
:
bmp.table20
All these tables have 'batch_id'... (1 Reply)
I have to export data from table into flat file with | delimited. In the ksh file, I am adding below to do this activity.
$DBSTRING contains the sqlplus command and $SQL_STRING contains the SQL query. File is created properly with the data as per SQL command. I am getting white spaces in the... (1 Reply)
I habe a UNIX Variablw with content as below:
WHOLE_REC_TXT="$record"
where $record contains contents of file
Sample contents of file:
topic_id|1624|AIDS-HIV||
topic_id|1625|Allergies||
topic_id|1626|Alzheimer s||
topic_id|1627|Knee Pain||
topic_id|1628|Autism||... (2 Replies)
Hello,
please help me an the below issue.
i need to check whether data is available or not in a flat file generated by oracle
(sometimes sql didn't any records) to overcome this.
without opening flat file.
Thanks....... (1 Reply)
Discussion started by: mahesh1987
1 Replies
LEARN ABOUT SUSE
drop_schema
DROP SCHEMA(7) SQL Commands DROP SCHEMA(7)NAME
DROP SCHEMA - remove a schema
SYNOPSIS
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP SCHEMA removes schemas from the database.
A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even
if he does not own some of the objects within the schema.
PARAMETERS
IF EXISTS
Do not throw an error if the schema does not exist. A notice is issued in this case.
name The name of a schema.
CASCADE
Automatically drop objects (tables, functions, etc.) that are contained in the schema.
RESTRICT
Refuse to drop the schema if it contains any objects. This is the default.
EXAMPLES
To remove schema mystuff from the database, along with everything it contains:
DROP SCHEMA mystuff CASCADE;
COMPATIBILITY
DROP SCHEMA is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart
from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER SCHEMA [alter_schema(7)], CREATE SCHEMA [create_schema(7)]
SQL - Language Statements 2010-05-14 DROP SCHEMA(7)