OraFAQ Forum: Server Utilities » import only certain number of rows in oracle

Home » RDBMS Server » Server Utilities » import only certain number of rows in oracle (Oracle 11g;window2007)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import only certain number of rows in oracle [message #593370]

Thu, 15 August 2013 23:29

mohan1760
Messages: 59
Registered: June 2008

Member

Hi,

I want to import only limited number of rows(say 100 rows from each table) from all tables but I want all proc/functions/packages etc to be imported.

Please suggest.

Report message to a moderator

Re: import only certain number of rows in oracle [message #593373 is a reply to message #593370]

Thu, 15 August 2013 23:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

doing as above could prove to be greatly problematic for any Primary Key/Foreign Key pair.
How do you ensure every child key has a parent key when randomly limiting row counts?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic:	SQL Loader or external table with a trigger
Next Topic:	Error using parfile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 12:54:52 CDT 2024