Sponsored Content
Top Forums UNIX for Dummies Questions & Answers How can I import a particular schema from full dump in Oracle? Post 302902129 by Palak Sharma on Monday 19th of May 2014 12:22:26 AM
Old 05-19-2014
But I do not want the full dump to import, the fulldb.dmp command contains full databse dump, I just want to import a single schema can u help me with this?
 

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
VOLDUMP(8)						       AFS Command Reference							VOLDUMP(8)

NAME
voldump - Dump an AFS volume without using the Volume Server SYNOPSIS
voldump -part <partition> -volumeid <volume id> [-file <dump file>] [-verbose] [-help] voldump -p <partition> -vo <volume id> [-f <dump file>] [-ve] [-h] DESCRIPTION
voldump dumps an AFS volume in the format used by vos dump without using the Volume Server. It must be run on the file server machine and usually must be run as the superuser "root" to have permissions to read the file server data. It's primary use is to recover data from a file server machine where the Volume Server cannot be started for some reason. The dump output will go to standard output, or to a file if -file is specified. vos restore can be used to load the resulting dump into a new AFS volume. voldump always does a full dump. CAUTIONS
Normally, use vos dump instead of this command. voldump is a tool of last resort to try to extract data from the raw data structures stored on the file server machine and is not as regularly tested or used as the normal vos dump implementation. If the AFS volume being dumped changes while voldump is running, the results may be inconsistent. If the File Server and Volume Server are running, stop them with bos shutdown or a similar method before running this command. OPTIONS
-part <partition> Names the partition on which the volume to be dumped is located. voldump does not take the normal full range of ways of specifying a partition. Instead, partition must be either a single letter between "a" and "z", corresponding to /vicepa through /vicepz, or the full path to the file server partition. "aa" is not recognized; use /vicepaa instead. -volumeid <volume id> Specifies the ID of the volume to dump. The volume must be specified by numeric ID, not by name. -file <dump file> Specifies the output file for the dump. If this option is not given, the volume will be dumped to standard output. -verbose Asks for a verbose trace of the dump process. This trace information will be sent to standard error. EXAMPLES
The following command dumps the volume 1936964939 on the /vicepb partition to the file /tmp/volume.dump: % voldump -part /vicepb -volumeid 1936964939 -file /tmp/volume.dump PRIVILEGE REQUIRED
The issuer must have read access to the file server data stored in the specified partition. Usually, this means that the issuer must be the local superuser "root" on the file server machine. SEE ALSO
bos_shutdown(8), restorevol(1), volserver(8), vos_dump(1), vos_restore(1) COPYRIGHT
Copyright 2005 Russ Allbery <rra@stanford.edu> This documentation is covered by the IBM Public License Version 1.0. This man page was written by Russ Allbery for OpenAFS. OpenAFS 2012-03-26 VOLDUMP(8)
All times are GMT -4. The time now is 03:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy