Or, how about connecting to the dev server, setting up a database link and issuing:-
This would drag the table direct between the two, negating the need to export/import.
Robin
This is certainly a valid way of moving data from one database to another. The only downside is that you would
need to manually created indexes, constraints and triggers. Once the table gets created you can also use a merge
command to update the local table from a remote table.
In this case either you have a directory that is visible to both databases and both databases have a database directory
pointing to the same OS directory, or you need to move the file yourself.
I am always curious when someone asks an Oracle question on a website more devoted to OS questions/issues.
While this is a great site there are other Oracle specific forums that are also worth looking at.
This User Gave Thanks to gandolf989 For This Post:
Where can I download the VTC - Unix Shell Scripting Advanced complete video.
I don't know in which thread I should post this question.Plz help me out, or just tell me the link in the reply to this post.
Thanks in advance. (0 Replies)
Hello all
i am working on creating shell script to download files daily
example : file12_10_2009.txt.gz
next day this file will be file13_10_2009.txt.gz
and so on..
i need help to know how to download this incrimental date files daily ?
regards (1 Reply)
I am new to shell scripting and need to write a program to copy files that are posted as links on a specific url. I want all the links copied with the same file name and the one posted on the webpage containing the url onto a specific directory. That is the first part. The second part of the script... (2 Replies)
Hi guys,
I'm new on this forum and on UNIX. Can somebody help in writing a script to download a file from an FTP server and validating if there is a file to download. If there is a file, I would send it to a mail recipient and if not I would generate an error log.
Thanks in advance!:D (1 Reply)
Hi Experts,
can guide how we can Update a Database Table using a txt file source Using
Unix Shell Scripts.
What are the Cron Jobs codes can written to Update DB table.
txt file contains record like data.
US 09/03/2012 User DocType DocID.
these above feilds in txt files need to be updated in... (4 Replies)
Hi !
I am just wondering shell script to download data from ftp...
I have text file containing ftp address...looks like this
ftp://site...../filename.xyz
ftp://site...../filename.xyz
ftp://site...../filename.xyz
ftp://site...../filename.xyz
script has to read ftp address and... (8 Replies)
Hello this is my first post in this forum , I dont want to be unhappy..
I am writing one script but facing difficulty to find the latest file with some new pattern
My requirement is
1. The file is coming like "ABCD-23220140303" at FTP server once in a week.
2. script will run on daily... (3 Replies)
Hi,
I have a video script. it has embedded Youtube videos. I want replace them downloaded version mp4 videos.
this script has a mysql table. I want search "url_flv" field on table a youtube link if has a youtube link I want download it this command.
I want extract uniq_id field for file... (2 Replies)
we are getting files on daily basis.we need to process these files.
i need a unix shell script where we can count
1-The no of files processed
2-No of data/record processed for each files.
The script should log these details into a database table. If there is any error while file... (3 Replies)
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
LEARN ABOUT DEBIAN
drop_table
DROP TABLE(7) SQL Commands DROP TABLE(7)NAME
DROP TABLE - remove a table
SYNOPSIS
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TABLE removes tables from the database. Only its owner can drop a table. To empty a table of rows without destroying the table, use
DELETE [delete(7)] or TRUNCATE [truncate(7)].
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 view or a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove a dependent view
entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.)
PARAMETERS
IF EXISTS
Do not throw an error if the table does not exist. A notice is issued in this case.
name The name (optionally schema-qualified) of the table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if any objects depend on it. This is the default.
EXAMPLES
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the IF
EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER TABLE [alter_table(7)], CREATE TABLE [create_table(7)]
SQL - Language Statements 2010-05-14 DROP TABLE(7)