Home » RDBMS Server » Server Utilities » import only certain number of rows in oracle (Oracle 11g;window2007)
import only certain number of rows in oracle [message #593370] Thu, 15 August 2013 23:29 Go to next message
Messages: 59
Registered: June 2008

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.
Re: import only certain number of rows in oracle [message #593373 is a reply to message #593370] Thu, 15 August 2013 23:41 Go to previous message
Messages: 24963
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:

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

Current Time: Tue Oct 25 16:12:21 CDT 2016

Total time taken to generate the page: 0.10259 seconds