|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
How to Import dump file with default value for single column?
Post 302816439 by GOVINDARAJ.M on Tuesday 4th of June 2013 02:18:31 AM
06-04-2013
Quote:
AFAIK there is no such option in export or import utilities that supports modifying column values.
These utilities are used if your data objects reside on platforms with different hardware and software configurations.
If that is not the case you can use COPY command in which you can specify modified value inSELECT statement.
These utilities are used if your data objects reside on platforms with different hardware and software configurations.
If that is not the case you can use COPY command in which you can specify modified value inSELECT statement.
But COPY command will work DB within the service ID.But I have DB as 'scott/tiger@aaaa' and 'scott/tiger@bbbb'.I dont want to run the update query manually.it will take so much time to update 250K of records.I need to do the same import/export process for 25 crore of records and this will take few days to complete.
|
|
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 X11R4
systemd-importd.service
SYSTEMD-IMPORTD.SERVICE(8) systemd-importd.service SYSTEMD-IMPORTD.SERVICE(8) NAME
systemd-importd.service, systemd-importd - VM and container image import and export service SYNOPSIS
systemd-importd.service /lib/systemd/systemd-importd DESCRIPTION
systemd-importd is a system service that allows importing, exporting and downloading of system images suitable for running as VM or containers. It is a companion service for systemd-machined.service(8), and provides the implementation for machinectl(1)'s pull-raw, pull-tar, import-raw, import-tar, export-raw, and export-tar commands. See the importd D-Bus API Documentation[1] for information about the APIs systemd-importd provides. SEE ALSO
systemd(1), machinectl(1), systemd-machined.service(8), systemd-nspawn(1) NOTES
1. importd D-Bus API Documentation https://www.freedesktop.org/wiki/Software/systemd/importd systemd 237 SYSTEMD-IMPORTD.SERVICE(8)