Home > IT Answers > Oracle > search string in oracle DMP file
Balajikalai
15 pts.
 search string in oracle DMP file
DMP Importing, Oracle, Oracle PL/SQL, PL/SQL, Search string
hi , i would like to write a pl/sql oracle code to search a string from Oralce DMP file.

e.g

<OWNER_NAME>[strong]xxx[/strong]</OWNER_NAME>

i want to get  [strong]XXX[/strong] as output .

any help would be really really appreciated

 

 

 



Software/Hardware used:
ASKED: September 30, 2010  12:01 AM
UPDATED: October 15, 2010  4:38 PM
RELATED QUESTIONS
Answer Wiki:
Are you referring to a DMP file created by the EXPORT utility ? If so, you can't. Those files can only be read by the IMPORT utility.
Last Wiki Answer Submitted:  September 30, 2010  10:53 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Carlosdl has is right. But you can try another way if your need is only for the DDL and NOT for the data rows. Using imp with the INDEXFILE option you can have a txt file containing all the DDL needed to create the objects included in the export file.

Hope this help

M.

FreCho
 80 pts.
 

Hi, I have text file data.txt
Content :
line1
line2
<owner>oralce<owner>
line3
<owner>oralce<owner>
line4

i would like write new pl/sql code to read a file and get the oralce as output from the <owner>oralce<owner> the string

Any help or advice would be really appreciated..

Balajikalai
 15 pts.
 

You will have to use the UTL_FILE package.

In the above link you will find information and examples on how to use it.

Let us know if you find specific problems when creating your procedure.

carlosdl
 63,535 pts.