Home » RDBMS Server » Server Utilities » Importing partial data from a full export dump
Importing partial data from a full export dump [message #73706] Tue, 22 June 2004 11:31 Go to next message
goodfrnd
Messages: 6
Registered: May 2004
Junior Member
Hi,

         Please help me in importing only partial data say 20% of data only from a export dump which is a full data base dump.

please let me know is it aloowed to do so and if yes how to I mean the command for doing it.

Thanks in advance.

 

Report message to a moderator

Re: Importing partial data from a full export dump [message #73710 is a reply to message #73706] Wed, 23 June 2004 01:22 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
You can extract any schema or a Table from a FULL Db dump but cannot extract rows partially from each table.

Regards
Himansh

Report message to a moderator

Re: Importing partial data from a full export dump [message #73719 is a reply to message #73706] Thu, 24 June 2004 03:20 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As Himanshu said, You cannot partially import the rows from a dump file.
still, you can do a partial export ( selected rows of a table) and import it.

Report message to a moderator

Previous Topic: statspack report
Next Topic: Oracle third party
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 10:26:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.