Home » RDBMS Server » Backup & Recovery » take a look a this
take a look a this [message #232205] Thu, 19 April 2007 15:41 Go to next message
Messages: 1
Registered: April 2007
Location: Paraguay
Junior Member
Hello, I have a question, I have a dmp file that contains a entire database, i need only a few records of one table, the table alone holds too many records soo the even if a import the table alone is too large.
Re: take a look a this [message #232208 is a reply to message #232205] Thu, 19 April 2007 15:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way to do it directly with imp.

Re: take a look a this [message #232213 is a reply to message #232208] Thu, 19 April 2007 16:08 Go to previous message
Messages: 157
Registered: April 2007
Location: USA
Senior Member

What exactly you want? Do you want to import few records from one big of table? If that so, you have to take export with QUERY clause and then you have to import, else you have to import specific table and you have to manually delete those records from the respective table.

Previous Topic: RMAN Error
Next Topic: Oracle Disaster recovery query - Veritas Volume replicator and Flashsnap
Goto Forum:

Current Time: Thu Aug 24 00:11:12 CDT 2017

Total time taken to generate the page: 0.09823 seconds