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
mohan1760
Messages: 57
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.
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
BlackSwan
Messages: 21942
Registered: January 2009
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/
Previous Topic: SQL Loader or external table with a trigger
Next Topic: Error using parfile
Goto Forum:
  


Current Time: Fri Apr 18 14:56:49 CDT 2014

Total time taken to generate the page: 0.24349 seconds