I have a client database on a remote server.
I take a daily export dump of this database.
Now, I have created a new Oracle 11g XE database on my local machine. I want to import that dump in this XE database.
I will ftp the dump file to local machine and all ... no isssues about that.
I just want to know will import in XE database be successful? I mean, can we import data in XE database ?
My source database (client database) is 184.108.40.206 and my target database (XE database) is 220.127.116.11
expdp and impdp are perfect for this. I prefer to do schema level imports if possible too.
You can also consider doing the import directly using a network link..
http://www.oracle-base.com/articles/10g ... rtsImports
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 11 guests