06-03-2013
How to Import dump file with default value for single column?
Hi,
I need to import more than 250K of records to another Database(Oracle).But I want particular column value to be changed in the destination table. Is it possible to do this during export or import process with out modifying data from original table.I do not want to run Update manually.
Thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi folks,
Happy new year.
I have a file 'filename' that i wd like to split basing on the contents in the last column.
The 'filename' content looks like
256772744788,9,11
256772744805,9,11
256772744792,9,11
256775543055,10,12
256782625357,9,12
256772368953,10,13
256772627735,10,13... (3 Replies)
Discussion started by: jerkesler
3 Replies
2. UNIX for Advanced & Expert Users
hi 2 all
i need to get single column from one csv file
anyone help me !
>cat file.csv
name,age
x,1
y,2
z,3
Use code tags please, ty.
in this "file.csv" file i need only name column
can u help me !:b::b: (7 Replies)
Discussion started by: ponmuthu
7 Replies
3. UNIX for Dummies Questions & Answers
Hi...
I have dump in unix machine...How can I this import dump to Oracle database?
Many thanks in advance. (2 Replies)
Discussion started by: agarwal
2 Replies
4. Shell Programming and Scripting
Hi,
I am trying to get the file in particular pattern using shell script. I have to add one column to some other file.
For example consider two file as below.
File1:
name1
name2
name3
File2:
Add1 age1
Add2 age2
Add3 age3
I want this two file in a single file format something like... (3 Replies)
Discussion started by: diehard
3 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump.
Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies
6. UNIX and Linux Applications
Hi All,
I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server.
Now how to import the dump to the... (3 Replies)
Discussion started by: Palak Sharma
3 Replies
7. UNIX and Linux Applications
Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (2 Replies)
Discussion started by: clerck
2 Replies
8. Shell Programming and Scripting
Hi,
I have 2 csv/txt files with single columns. I am trying to merge them using paste, but its not working..
output3.csv:
flowerbomb
everlon-jewelry
sofft
steve-madden
dolce-gabbana-watchoutput2.csv:
http://www1.abc.com/cms/slp/2/Flowerbomb
http://www1.abc.com/cms/slp/2/Everlon-Jewelry... (5 Replies)
Discussion started by: ajayakunuri
5 Replies
9. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
are the oracle dump files compatible to direct import into db2?
I already tried many times but it always truncated results.
anyone can help/ advice or suggest?
2. Relevant commands, code, scripts, algorithms:
exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
10. Solaris
On an OmniOS server, I removed a single-disk pool I was using for testing.
Now, when I run zpool import it will show it as FAULTED, since that single disk not available anymore.
# zpool import
pool: fido
id: 7452075738474086658
state: FAULTED
status: The pool was last... (11 Replies)
Discussion started by: priyadarshan
11 Replies
LEARN ABOUT DEBIAN
nicotine-import-winconfig
NICOTINE(1) General Commands Manual NICOTINE(1)
NAME
nicotine-import-winconfig - import configuration from the Windows soulseek client
SYNOPSIS
nicotine-import-winconfig [OPTIONS] old-config-file
DESCRIPTION
This manual page documents briefly the nicotine-import-winconfig command. This manual page was written for the Debian distribution because
the original program does not have a manual page.
nicotine-import-winconfig is a program to import your queue, user list, password information, auto-joined chatrooms, banlist, and user
information from the Windows SoulSeek configuration.
USAGE
A typical invocation would be :
nicotine-import-winconfig "/mnt/win9x/Program Files/SoulSeek"
The program should be run when nicotine is not running. It will add the information (download queue, userlist, password info, etc.) to the
existing configuration or write a new configuration from scratch when no configuration exists.
FILES
$HOME/.nicotine/config
The per-user configuration file for nicotine(1) will be overwritten.
You might want to back up the file first, but it should not be necessary. A different config file can be chosen using the --config flag.
configfile-userinfo.ext
In case there's an image included in the Windows SoulSeek userinfo, the image will be extracted and written to that file, where con-
figfile is the path to your nicotine configuration file, and ext is the appropriate file extension for the image type.
OPTIONS
When you don't want to import all configuration options, you can choose what to import using command line flags.
-c file | --config=file
Use a non-default nicotine configuration file to write to.
-q | --queue
Import the queue.
-u | --userlist
Import the userlist.
-l | --login
Import the login information.
-C | --chatrooms
Import the list of autojoined chatrooms.
-b | --banned
Import the list of banned users.
-i | --userinfo
Import the user information and the image.
-h | --help
Print the summary of command line options and exit.
TIPS
It is possible to share the download directory between platforms. Nicotine can even continue downloads that started using the Windows
client.
Of course, the download directories should be the same for nicotine and Windows, e.g. if your Windows sharing directory is F:slsk_in and
your F drive is mounted on /mnt/media, then you must set your download directory to /mnt/media/slsk_in.
SEE ALSO
nicotine(1).
AUTHOR
Geert Kloosterman <geertk@ai.rug.nl>, 2003.
August 25, 2003 NICOTINE(1)