Oracle Exports remote library DMP files and imports them into a local Oracle database for replication and porting of remote databases.

Do you have this kind of trouble, want to turn the company project into its own project resource pool. But the project was completely copied down to its own machine to run, found the inability to access the remote database error, in order to solve this problem, the author tried to import the remote database into the local database operation, encountered a little trouble, make a record.

Import Script:

--Table SpaceCREATEtablespace ecdatafile'd:\tablespace\ec.dbf'size 3000M EXTENT MANAGEMENT LOCAL SEGMENTSPACEMANAGEMENT AUTO; --2. Build UsersCreate UserJelly identified byTigerdefaulttablespace EC;--3. EmpoweringGrantConnect,resource toJelly;Grant Create  anySequence toJelly;Grant Create  any Table  toJelly;Grant Delete  any Table  toJelly;Grant Insert  any Table  toJelly;Grant Select  any Table  toJelly;GrantUnlimited tablespace toJelly;Grant Execute  any procedure  toJelly;Grant Update  any Table  toJelly;Grant Create  any View  toJelly

--imp Scott/Tiger@orclfile=d:\ec.dmp fromuser='  ecuser' touser='jelly' ignore=y  

-- Delete User and user objects Drop User Cascade;

-- Delete Table Space DROP  and datafiles;

http://blog.csdn.net/starnight_cbj/article/details/6792364

Oracle Exports remote library DMP files and imports them into a local Oracle database for replication and porting of remote databases.