IMPDP oracle 11g XE

[Ninadgarude]

Hi,

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 11.2.0.1 and my target database (XE database) is 11.2.0.2

[Ninadgarude]

I think I got the solution. I did schema level impdp. It worked.

[Tim...]

Hi.

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

Cheers

Tim...