I'm an amateur and need your help in figuring this out. I have been asked to connect to a prod db from non-prod env., and download a table from prod db to non-prod env.
I was able to connect to the prod db and then run a simple query as below.
Code:
@@@@@@@@@@
X=`$ORACLE_HOME/bin/sqlplus id/pwd@"prod_db"<<eof
set serveroutput on;
set feedback off;
set linesize 1000;
select count(*) from table;
EXIT;
eof`
echo $X>dbconn.dat
@@@@@@@@@@
and I got the result with count and lot of other text relaed to Oracle product.
Can you please advise as to how would I download an entire table from the prod_db and load into a non_prod db under my schema ? Basically, below are what I need to do.
connect to prod_db
download/unload a table from prod_db
load the same table into another non_prod db under my schema
then compare myschema.table with system_schema.table in non_prod db
then replace system_schema.table with myschema.table
I will be working on how to figure all of above but since I'm running short on time, would like to get some help
Thanks in advance
Arun
Last edited by rbatte1; 09-12-2016 at 09:50 AM..
Reason: Converted to formatted number-list
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
rabbitmq-env.conf
RABBITMQ-ENV.CONF(5) RabbitMQ Server RABBITMQ-ENV.CONF(5)NAME
rabbitmq-env.conf - default settings for RabbitMQ AMQP server
DESCRIPTION
/etc/rabbitmq/rabbitmq-env.conf contains variable settings that override the defaults built in to the RabbitMQ startup scripts.
The file is interpreted by the system shell, and so should consist of a sequence of shell environment variable definitions. Normal shell
syntax is permitted (since the file is sourced using the shell "." operator), including line comments starting with "#".
In order of preference, the startup scripts get their values from the environment, from /etc/rabbitmq/rabbitmq-env.conf and finally from
the built-in default values. For example, for the RABBITMQ_NODENAME setting,
RABBITMQ_NODENAME
from the environment is checked first. If it is absent or equal to the empty string, then
NODENAME
from /etc/rabbitmq/rabbitmq-env.conf is checked. If it is also absent or set equal to the empty string then the default value from the
startup script is used.
The variable names in /etc/rabbitmq/rabbitmq-env.conf are always equal to the environment variable names, with the RABBITMQ_ prefix
removed: RABBITMQ_NODE_PORT from the environment becomes NODE_PORT in the /etc/rabbitmq/rabbitmq-env.conf file, etc.
# I am a complete /etc/rabbitmq/rabbitmq-env.conf file.
# Comment lines start with a hash character.
# This is a /bin/sh script file - use ordinary envt var syntax
NODENAME=hare
SEE ALSO rabbitmq-server(1)rabbitmqctl(1)EXAMPLES
# I am a complete /etc/rabbitmq/rabbitmq-env.conf file.
# Comment lines start with a hash character.
# This is a /bin/sh script file - use ordinary envt var syntax
NODENAME=hare
This is an example of a complete /etc/rabbitmq/rabbitmq-env.conf file that overrides the default Erlang node name from "rabbit" to "hare".
AUTHOR
The RabbitMQ Team <info@rabbitmq.com>
RabbitMQ Server 06/22/2012 RABBITMQ-ENV.CONF(5)
09-09-2016
