Solved

perl script for export/import Oracle database

Posted on 2010-08-12
3
591 Views
Last Modified: 2012-05-10
HI,
I am new for perl scripting.
I need a sample  perl script to export  two Oracle schemas  from one server  and  import  both schemas to another server.
Advance Thanks.

subbu
0
Comment
Question by:Subramanyeswara
  • 2
3 Comments
 
LVL 9

Expert Comment

by:Suhas .
ID: 33426827
0
 
LVL 2

Author Comment

by:Subramanyeswara
ID: 33429242

I know, How to use export and import commands in oracle. I need perl script todo export and import.
0
 
LVL 2

Accepted Solution

by:
Subramanyeswara earned 0 total points
ID: 33432864
Thanks Suhasbharadwaj

I got solution:

print `exp system/$passwd\@$instance BUFFER=40960 file=$file_loc\file.dmp owner=$schema consistent=y log= $file_loc\exp.log`;
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now