Sponsored Content
Full Discussion: Import dump to database
Top Forums UNIX for Dummies Questions & Answers Import dump to database Post 302534176 by agarwal on Monday 27th of June 2011 06:16:31 AM
Old 06-27-2011
Import dump to database

Hi...

I have dump in unix machine...How can I this import dump to Oracle database?

Many thanks in advance.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

help, what is the difference between core dump and panic dump?

help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies

2. UNIX for Dummies Questions & Answers

Importing a unix file dump into a PC capable database

My development team has been trying to figure out how to import a unix data dump into SQL Server or convert it into an intermediate file format for several days. The data dump in question looks like this: $RecordID: 1<eof> $Version: 1<eof> Category: 1<eof> Poster: John Doe<eof>... (7 Replies)
Discussion started by: DaltonF
7 Replies

3. Shell Programming and Scripting

getting dump from database by UNIX script

can i make a dump to happen from my script in a databse.and download that dump. I want to schedule a script i cron so that i will make a dump and download that inot my server. (1 Reply)
Discussion started by: arunkumar_mca
1 Replies

4. UNIX for Dummies Questions & Answers

SSH import mysql database

Hi all, I am trying to import a database in putty with the syntax: mysql –u database_username –p database_name < filename.mysql As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives... (2 Replies)
Discussion started by: Juc1
2 Replies

5. UNIX for Dummies Questions & Answers

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. ... (6 Replies)
Discussion started by: GOVINDARAJ.M
6 Replies

6. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

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

7. UNIX and Linux Applications

How to import and dump file to remote Oracle server?

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

8. UNIX and Linux Applications

Problem in import & expdp Dump file

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

9. Shell Programming and Scripting

Data to import the database as snippets

Hi all, I don't know if this the right place to post my question to get some ideas on how to done this. I have a text files extracted from OCR that need to have snippets to be import to database as snippet table which have columns "snippet, date, title" I dont know if shell scripts can do it... (11 Replies)
Discussion started by: lxdorney
11 Replies

10. Homework & Coursework Questions

Oracle dump file (del format) import into db2

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
CFETOOLDUMP(8)						User Contributed Perl Documentation					    CFETOOLDUMP(8)

NAME
cfetooldump - dump the contents of a database in XML format SYNOPSIS
cfetool dump name [--path|-p directory name] [--file|-f filename] [--daily|-d] [--weekly|-w] [--yearly|-y] [--verbose|-v] [--help|-h] DESCRIPTION
Prints the contents of the specified database in XML format, with comments for human readability. This format can be read by cfetool import. The -d, -w, and -y options specify which databases to include in the dump, and may be combined. If they are all omitted, the default is to only dump the weekly database. OPTIONS
--path|-p directory name Names the directory in which the database specified by name can be found. --file|-f filename Names a file to print the XML to. If this option is omitted, the XML will be printed to the standard output stream. --daily|-d Include the daily pattern database in the dump. --weekly|-w Include the weekly pattern database in the dump. --yearly|-y Include the yearly pattern database in the dump. --verbose|-v Print details of the command's execution to the standard output stream. When using this argument, it is recommended that you also pro- vide the -f argument, to avoid sharing the standard output stream. --help|-h Print a short help message and then exit. EXAMPLE
% cfetool dump temperature --path /my/path -f temperature.xml Prints the following to the file temperature.xml: <!-- cfetool Database Dump --> <dump> <name> temperature </name> <age> 1 </age> <!-- steps (0.001 weeks) --> <step> 10 </step> <!-- minutes --> <!-- consecutive updates --> <iterations> 1 </iterations> <!-- last update at Tue Aug 31 10:32:05 2004 --> <timestamp> 1093973525 </timestamp> <!-- current weighted average --> <expect> 7.105000 </expect> <!-- current variance --> <var> 38.280217 </var> <!-- data entries --> <entry> <timekey> Tue:Hr10:Min30_40 </timekey> <expect> 10.150000 </expect> <var> 13.245750 </var> </entry> </dump> AUTHORS
The code and documentation were contributed by Stanford Linear Accelerator Center, a department of Stanford University. This documentation was written by Elizabeth Cassell <e_a_c@mailsnare.net> and Alf Wachsmann <alfw@slac.stanford.edu> COPYRIGHT AND DISCLAIMER
Copyright 2004 Alf Wachsmann <alfw@slac.stanford.edu> and Elizabeth Cassell <e_a_c@mailsnare.net> All rights reserved. perl v5.8.4 2004-09-21 CFETOOLDUMP(8)
All times are GMT -4. The time now is 03:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy