Sponsored Content
Top Forums UNIX for Dummies Questions & Answers How can I import a particular schema from full dump in Oracle? Post 302901898 by gandolf989 on Friday 16th of May 2014 09:14:40 AM
Old 05-16-2014
Quote:
Originally Posted by Palak Sharma
Code:
imp rdsuser@oracledb FILE=fulldb.dmp TOUSER=rdsuser FROMUSER=SYSTEM FULL=Y buffer=100000

So far I have tried this but it imports entire database. I need to import a particular schema
In addition to removing FULL=Y, why are you importing into system? System is a special account. You should create a different user and import into that user.

Also imp dates back to 7.3.4 and probably before that. You should start using impdp or data pump. With data pump and enterprise edition you can compress the export, use multiple channels and change table space names and user names on import. data pump has a lot more functionality than the old exp/imp. Of course you need to run at least 9i to use data pump.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script for checking schema satistics in Oracle

I have a script which gives the output of schemas in Oracle DB : #!/bin/ksh ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL do if ; then ORACLE_HOME=/u01/app/oracle/product/9.2.0 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:. ... (0 Replies)
Discussion started by: run_time_error
0 Replies

2. UNIX and Linux Applications

Toad for Oracle 11G - schema browser not working

Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue (0 Replies)
Discussion started by: girija
0 Replies

3. UNIX for Dummies Questions & Answers

Import dump to database

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. Emergency UNIX and Linux Support

Toad for Oracle 11G Schema browser

Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue.. I need it asap thats y posted here Thanks (5 Replies)
Discussion started by: girija
5 Replies

5. Shell Programming and Scripting

Parallel export of all oracle DB schema.

In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one. But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies

6. 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

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. 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
PUMP(8) 						   Linux Administrator's Manual 						   PUMP(8)

NAME
pump - configure network interface via BOOTP or DHCP protocol SYNOPSIS
pump [-krRsd] [-c|--config-file FILE] [-h|--hostname HOSTNAME] [-i|--interface IFACE] [-l|--lease HOURS] [-m|--route-metric METRIC] [--lookup-hostname] [--no-dns] [--no-gateway] [--no-ntp] [--no-setup] [--release] [--renew] [--script= ISCRIPT] [--status] [--win-client-ident] pump [-?|--help] [--usage] DESCRIPTION
pump is a daemon that manages network interfaces that are controlled by either the DHCP or BOOTP protocol. While pump may be started manually, it is normally started automatically by ifup(8) for devices configured via BOOTP or DHCP. If pump is managing an interface, you can run it again to query the status of that interface. For example, pump -i eth0 --status will print the current status of device eth0. COMMAND LINE OPTIONS
switch long option description -? --help Show this help message -c --config-file=FILE Get configuration from FILE instead of /etc/pump.conf -d --no-dns Don't update DNS resolver configuration -h --hostname=HOSTNAME Request HOSTNAME -i --interface=IFACE Manage IFACE rather than eth0 --keep-up Keep the interface up when released -k --kill Kill daemon (and disable all interfaces) -l --lease=HOURS Request least time of HOURS --lookup-hostname Look up hostname in DNS -R --renew Renew lease immediately -r --release Release interface -m --route-metric=METRIC Metric to use on routes (normally 0) --no-gateway Don't configure a default route for this interface --no-resolvconf Don't use the resolvconf program to update resolv.conf --no-ntp Don't update ntp.conf --no-setup Don't set up anything --script=SCRIPT Call SCRIPT (or null string to disable) -s --status Display interface status --usage Display a brief usage message --win-client-ident Specify a Windows(tm)-like client identifier OPTION NOTES
The --lookup-hostname option causes pump to ignore the host and domain names returned by the server and instead to look these up in DNS using the IP address of the interface. The name that is looked up is used in forming the search line in the resolv.conf file. Thus, if either the --no-dns or domainsearch option is used then --lookup-hostname has no effect. Note that pump itself never sets the computer's hostname. CONFIGURATION FILE
You can tune the behavior of pump using a configuration file. By default pump reads /etc/pump.conf but you can change this using the --config-file option. The configuration file is line-oriented. Most lines contain a directive followed by zero or more arguments. Arguments are handled simi- larly to how shells handle command arguments, allowing the use of quotes and backslash escapes. Comments are allowed, and must begin with a # character. Spaces and tabs are ignored. Directives may be specified at two levels: global and specific. Global directives change pump's behavior for all of the devices that it manages whereas specific directives change pump's behavior for a single device. Later directives always override earlier ones. Here is an example configuration file: # sample /etc/pump.conf file domainsearch "my.own.org own.org at.work.com" retries 3 device eth1 { nodns } This configuration file tells pump to use a specific DNS search path rather than deriving one from the DHCP or BOOTP server response, to retry each request 3 times (for a total of 4 tries), and not to change the DNS configuration file when it's configuring the eth1 device. Here is a complete list of directives: device DEVICE Specify specific directives for DEVICE. This directive must be followed by a {, and the list of specific directives must end with a } on its own line. These directives may not be nested. domainsearch SEARCHPATH Use SEARCHPATH as the DNS search path instead of the domain name returned by the server or the domain part of the fully qualified hostname. keepup Keep the interface up when released. Normally pump brings the interface down when it releases its lease, but some daemons such as ifplugd or wpa_supplicant still need the interface to be up so that they can still work. nonisdomain Don't set the NIS domain. Normally pump sets the system's NIS domain if an NIS domain is specified by the DHCP server and the cur- rent NIS domain is empty or localdomain. nodns Don't update /etc/resolv.conf when the interface is configured. nogateway Ignore any default gateway suggested by the DHCP server for this device. This can be useful on machines with multiple devices. nontp Don't update /etc/ntp.conf when the interface is configured. nosetup Don't set up anything on the local machine as a result of DHCP operations. This implies nodns, nonisdomain, nogateway and nontp. This option is useful, for example, if you want to perform setup in customised scripts. noresolvconf Don't use the resolvconf program to update /etc/resolv.conf; instead, update /etc/resolv.conf directly. (This option is only rele- vant if --nodns is not used.) retries COUNT Retry each phase of the DHCP process COUNT times. timeout COUNT Don't let any one step of the DHCP process take more then COUNT seconds. script FILE Condition arg1 arg2 arg3 lease up eth0 1.2.3.4 renewal renewal eth0 2.3.4.5 release down eth0 When events occur in negotiation with the server, call the executable FILE. Scripts are called when a lease is granted, when a renewal is negotiated, and when the interface is brought down and the address released. The script is called with two or three arguments, depending on the condition, as documented in the table above. LOGGING
The program logs a good deal of information to syslog, much of it at the DEBUG level. If you're having trouble, it's a good idea to turn up syslog's logging level. BUGS
At startup pump tries to detect whether another instance of itself is running. If the UNIX domain socket (normally /var/run/pump.sock) does not exist, pump tries to connect to tcp/127.0.0.1:68. If it is also unreachable (possibly due to packet filtering), pump will issue a warning to stderr and assume that there is no instance of itself running. Probably limited to Ethernet, might work on PLIP, probably not ARCnet and Token Ring. The configuration file should let you do more things. Submit bug reports at the Bug Track link at http://developer.redhat.com/ QUIBBLE
A pump, like a boot[p], is something you wear on your foot. Some of us like the name (I know, hard to believe)! Linux 26 August 2004 PUMP(8)
All times are GMT -4. The time now is 10:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy