search string in oracle DMP file

15 pts.
Tags:
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

 

 

 

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • FreCho
    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.
    95 pointsBadges:
    report
  • Balajikalai
    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..
    15 pointsBadges:
    report
  • carlosdl
    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.
    69,920 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following