Home » RDBMS Server » Server Utilities » export the dmp file with specific records.
export the dmp file with specific records. [message #73303] Thu, 18 March 2004 20:44 Go to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
dear sir,
i have same application installed on different locations. now i want to back up the export file of the specific record...it is possible to export the specific record of the database..
thx for help

Report message to a moderator

Re: export the dmp file with specific records. [message #73305 is a reply to message #73303] Fri, 19 March 2004 02:04 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
yes

you can do that if your using oracle 8i. with QUERY parameter in export utility this is new parameter i oracle 8i

say if you have EMP table then if you wann to export of only those records whose salary is greater 3000

then in export parameter along with other parameter

u can specify like this

query='where sal>3000' but please check out your O/S

this example will work on NT/2000

Report message to a moderator

export the dmp file with specific records. [message #73306 is a reply to message #73305] Fri, 19 March 2004 18:54 Go to previous message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
pls send me the query of export specific records...

Report message to a moderator

Previous Topic: SQL*PLUS COPY (IMPORT EXPORT)
Next Topic: Oracle on UNIX
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 05:23:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.