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.