Home » RDBMS Server » Server Utilities » importing limited data in oracle (ORACLE Release 9.2.0.5.0, SunOS 5.8)
importing limited data in oracle [message #463033] Tue, 29 June 2010 08:18 Go to next message
amit.sehrawat
Messages: 29
Registered: September 2009
Location: India
Junior Member
Hi,

I have received a dump, which i need to put on a newly created schema, there is a particular table with more then 4 million rows, and other tables have hardly few thousand rows.

I want to import it in a way where only 1000 rows get imported for this table and other tables do not get affected.

Is there a way to do it?

Note: Tables in dump are more then 200.

Report message to a moderator

Re: importing limited data in oracle [message #463035 is a reply to message #463033] Tue, 29 June 2010 08:34 Go to previous messageGo to next message
CajunVarst
Messages: 55
Registered: April 2010
Location: Washington, D.C.
Member
I'm not sure that there is a way to do that during the import. You can selectively export using the query clause, but that does not exist for imp.

Report message to a moderator

Re: importing limited data in oracle [message #463039 is a reply to message #463035] Tue, 29 June 2010 08:36 Go to previous messageGo to next message
amit.sehrawat
Messages: 29
Registered: September 2009
Location: India
Junior Member
Yes, i know while exporting you can give number of rows, is there a way i do not import any data for particularly this table.
Note: i have more then 200 tables.

Report message to a moderator

Re: importing limited data in oracle [message #463046 is a reply to message #463039] Tue, 29 June 2010 08:44 Go to previous messageGo to next message
CajunVarst
Messages: 55
Registered: April 2010
Location: Washington, D.C.
Member
You can not import any data for this table by doing a rows=n, but you cannot import just a subset, which is what you had asked.

Report message to a moderator

Re: importing limited data in oracle [message #463055 is a reply to message #463046] Tue, 29 June 2010 08:57 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
If datapump was used for the export,then you can do an selective import using datapump with the query option.

Report message to a moderator

Re: importing limited data in oracle [message #463057 is a reply to message #463055] Tue, 29 June 2010 09:04 Go to previous messageGo to next message
CajunVarst
Messages: 55
Registered: April 2010
Location: Washington, D.C.
Member
True, but since title indicates 9.2, it was assumed that standared imp/exp was used. As since, datapump was not introduced until oracle 10.

Report message to a moderator

Re: importing limited data in oracle [message #463058 is a reply to message #463057] Tue, 29 June 2010 09:04 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
Ahh missed the notation on version 9.2

Report message to a moderator

Re: importing limited data in oracle [message #463060 is a reply to message #463039] Tue, 29 June 2010 09:27 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There are some ugly workarounds depending on your data.
For example, If there is a column with sequential values, you can precreate the table with a check constraint on the column.

[Updated on: Tue, 29 June 2010 09:28]

Report message to a moderator

Previous Topic: need help with export/import
Next Topic: SQL Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 14:00:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.