importing a single dumpfile in multiple databases at a time
Hi Folks,
I got request from my client side like follows,
They have a dump file of one schema called belin(schema name).
With that dump file i need to import to three databases called
1. gelixu1
2. gelixu2
3. gelixu3
in parallel manner (it means at a time.).. All my three databases are running in same server.
Mostly for single database it will take 1.5 Hours. but this time client had given only 2 hours for all the three databases.
Kindly let me know the possible ways.
way 1:
i thought of importing in three data bases in three session with a single dump file. What my doubt is, when importing in single database will it make any lock on a dump file, So other two databases cant use in parallel manner.
or
any other commands like
impdp username/passwd@ gelixu1,gelixu2,gelixu3
are there?