Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: exceptions in import
Top Forums Shell Programming and Scripting exceptions in import Post 302126730 by robotronic on Thursday 12th of July 2007 03:38:23 PM
Old 07-12-2007
Unfortunately, you cannot perform a FULL database import with the exception of some tables. To partially solve your problem, you can import one schema at a time, specifying the import parameter "OWNER" and leaving aside the schema which comprises the large tables (assuming these tables are located only in one certain schema). Notice that you must first create all the empty schemas before importing the users one by one.
Then, you have to manually import all the remaining tables of the last user excluding the large tables. Or, more precisely, you have to import all the tables except the large tables, using the option "TABLES=...". You may need to use a parfile if the table listing is very long!

Keep in mind that in this way you lose all the cross-schema's references (grants) and all the public objects, so at the end you may perform a full database import of the database definitions only (ROWS=N IGNORE=Y).

The other idea is to create only the schema which owns the large tables in your barely new db, then manually create these large tables specifying very small storage parameters (initial, next, maxextents=1). Finally, you can try to perform a full database import with the option IGNORE=Y. In this manner, the import of the large tables will fail but the database import will continue until the end.

The last and better method is to use Oracle Data Pump (expdp/impdp) instead of the normal export/import method. In this way you have the possibility to obtain a fine-grained import of your dump file, excluding only the objects you don't need. Of course, this implies you are using Oracle 10g Smilie

Bye
 

10 More Discussions You Might Find Interesting

1. Solaris

How to catch and handle Makefile exceptions

I have a simple makefile which I use to sync libraries files from /source/sybase directory on the source machine where the Makefile resides to /destination/folder on the various destination machines like machine1, machine2, machine3 using solaris utility 'rsync'. So when I run "make -f makefilename... (7 Replies)
Discussion started by: waavman
7 Replies

2. UNIX for Advanced & Expert Users

Remove directory with exceptions

Hi, I want to remove a directory recursively except the inside directories calles .SYNC (designsync dirs) I am looking for something like: \rm -rf < find . * | grep -v .SYNC The find works ok but I do not know how to redirect it. Please help. Regards, Ziv:rolleyes: (1 Reply)
Discussion started by: zivsegal
1 Replies

3. Shell Programming and Scripting

Remove directory with exceptions

Hi, I want to remove a directory recursively except the inside directories calles .SYNC (designsync dirs) I am looking for something like: \rm -rf < find . * | grep -v .SYNC The find works ok but I do not know how to redirect it. Please help. Regards, Ziv (3 Replies)
Discussion started by: zivsegal
3 Replies

4. UNIX for Advanced & Expert Users

java Exceptions color

Hi, I call a java program from a cron job and i need to display the exceptions or Errors thrown by java(basically stacktrace) in the unix/linux console in the red color.Is it possible to do that? If so, pls. give me some pointers how to do that. eg: Exception in thread "main"... (0 Replies)
Discussion started by: ramse8pc
0 Replies

5. UNIX for Dummies Questions & Answers

Diff with exceptions Question

So I'm currently developing an automated test system and I'm verifying my results by running a set of baselined data through and comparing the output (which is in a txt file) to a baseline results file. So of course I'm just using the diff command. Unfortunately each time I run the test there are 2... (3 Replies)
Discussion started by: Smitty0881
3 Replies

6. Programming

Relationship between exceptions and signals

Hi everyone, I am using AIX 6.1. There are exception codes defined in header file sys/m_except.hAlso, in the documentation (in "Understanding exception handling") it says: If no exception handler is currently defined when an exception occurs, typically one of two things happens. If... (0 Replies)
Discussion started by: manolo123
0 Replies

7. Shell Programming and Scripting

capturing exceptions from an scp clause

hpunix I have a script, that will scp -p a file. The server has keys set up. So I don't even pass a username. scp -p filename server:/directory There is a small chance that I can get an error. could be networking, etc... this is run from a job. I like to capture all exceptions when I do... (1 Reply)
Discussion started by: guessingo
1 Replies

8. IP Networking

SIGUP Exceptions during the execution

hello, I am getting SIGUP Exceptions during an execution of a procedure. Below is the log: Type: SignalException Message: SIGHUP Backtrace: 12:38 PM Action threw an exception: SIGHUP 12:38 PM Action threw an exception: SIGHUP E, ERROR -- : Type: SignalException Message: SIGHUP... (1 Reply)
Discussion started by: Deepthi.Prakash
1 Replies

9. Shell Programming and Scripting

Wildcards and exceptions

Hello: I have a very basic question. I'd like to select all files except for one file. For example, say I want to move all of the files in my current directory to a subdirectory called archive, I would use mv ./* archive/ But what if I want to move all files except for README.txt? Is there an... (19 Replies)
Discussion started by: Danny.Boy
19 Replies

10. Shell Programming and Scripting

RegEx with exceptions

I am totaly new to RegEx, but I need to extract emails with RegEx from text file Some difficulties: 1. “@”symbol has been substituted for “ at ”,"AT" or "(at)" 2. I do not need any email with domain "myoldcompany" I found that with these I can found any emails: "^+@+\.+$" How to do... (1 Reply)
Discussion started by: AIX_30
1 Replies

LEARN ABOUT LINUX

ssh-import-id

ssh-import-id(1)						    ssh-import							  ssh-import-id(1)

NAME

       ssh-import-id  -  retrieve one or more public keys from a public keyserver (Launchpad.net by default) and append them to the current user's
       authorized_keys file (or some other specified file)

SYNOPSIS

       ssh-import-id [options] USER_ID_1 [USER_ID_2] ... [USER_ID_n]

OPTIONS

	-h | --help	   usage
	-o | --output F    write output to file 'F' (default ~/.ssh/authorized_keys, use "-" for standard out)

DESCRIPTION

       This utility will securely contact a public keyserver (https://launchpad.net by default) and retrieve one or more user's public	keys,  and
       append these to the current user's ~/.ssh/authorized_keys file.

       The  system  administrator  can	change	the source URL used by ssh-import-id(1) by editing the configuration file, /etc/ssh/ssh_import_id,
       which is sourced to obtain the value of URL.  By default, URL="https://launchpad.net/~%s/+sshkeys".  Note that this url really  MUST  be  a
       secure,	https  url with a valid, signed certificate or else your system will be vulnerable to man-in-the-middle attacks!  The "%s" will be
       populated by ssh-import-id(1) with the value(s) of USER_ID_1 [USER_ID_2] ... [USER_ID_n].

SEE ALSO

       ssh(1)

FILES

       /etc/ssh/ssh_import_id

AUTHOR

       This manpage and the utility was written by Dustin Kirkland <kirkland@canonical.com> for Ubuntu systems (but may be used by others).   Per-
       mission	is  granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 3 published
       by the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

ssh-import							    23 Feb 2010 						  ssh-import-id(1)
All times are GMT -4. The time now is 05:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy