IMPDP oracle 11g XE

All posts relating to Oracle database administration.

Moderator: Tim...

IMPDP oracle 11g XE

Postby Ninadgarude » Thu Sep 20, 2012 11:17 am

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
Member
 
Posts: 22
Joined: Thu Aug 09, 2012 11:09 am

Re: IMPDP oracle 11g XE

Postby Ninadgarude » Thu Sep 20, 2012 12:37 pm

I think I got the solution. I did schema level impdp. It worked.
Ninadgarude
Member
 
Posts: 22
Joined: Thu Aug 09, 2012 11:09 am

Re: IMPDP oracle 11g XE

Postby Tim... » Thu Sep 20, 2012 5:20 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
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
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest