exceptions in import


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting exceptions in import
# 1  
Old 07-12-2007
exceptions in import

Hello,

I want to import an Oracle database file on my fresh DB, bought before successfully with exp command.
But is it possible to import some tables from the dmp file, because they are too large and it's so long !?
I didn't find any option in imp command to make exception on certain tables...

Thanks for your replies
Regards
# 2  
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
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
Login or Register to Ask a Question