Sponsored Content
Full Discussion: Import dump to database
Top Forums UNIX for Dummies Questions & Answers Import dump to database Post 302534223 by jayan_jay on Monday 27th of June 2011 07:51:04 AM
Old 06-27-2011
sample code:

Code:
imp <db_username>/<db_pwd> file = <dump_file_full_path_in_unix_machine> tables=(tablename1,tablename2,........ )


Last edited by Scott; 06-27-2011 at 08:56 AM.. Reason: Code tags, please...
 

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
c-icap-mkbdb(8) 					      System Manager's Manual						   c-icap-mkbdb(8)

NAME
c-icap-mkbdb - simple ICAP clientutility to create Berkeley DB lookup tables SYNOPSIS
c-icap-mkbdb [ -d debug_level ] [ -i file.txt ] [ -o file.db ] [ -t string|int|ip ] [ -v string|int|ip ] [ --dump ] DESCRIPTION
c-icap-mkbdb utility can be used to create Berkeley DB databases which can be used as lookup tables by the c-icap server. OPTIONS
-d debug_level The debug level -i file.txt The file contains the data (required). The line format of this file must be: key: value1, value2, .... -o file.db The database to be created -t string|int|ip The type of the key. Select string for string keys, int for integer keys or ip for using IP addresses as keys. The "string" is the default. -v string|int|ip The type of the values. The "string" is the default. --dump Do not update the database just dump it to the screen. EXAMPLES
c-icap-mkbdb -o keys -i keys.txt It builds the keys Berkeley DB database, using string type for keys and values. c-icap-mkbdb -o keys --dump Dump the contents of the keys database SEE ALSO
c-icap(8) c-icap-client(8) c-icap-stretch(8) c-icap-config(8) c-icap-libicapapi-config(8) AUTHOR
Tsantilas Christos c_icap 0.1.6 c-icap-mkbdb(8)
All times are GMT -4. The time now is 08:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy