Re: import issue

On Apr 27, 11:38 am, sam <samuel_st..._at_yahoo.com.br> wrote:
> I receive a dump of a schema from an external db and I got to import
> it on my db. This have to be done on a daily basis.
> Problem: There are objects on the dump specifically mapped to various
> tablespaces, that did not exists on my db, and when I do the import
> with the 'fromuser' 'touser', it does the imp from some objects,
> mapping them from the default tablespace of the user on my db, but it
> fails on the tables with *lobs...

Use the new data pump export and import. You can remap tablespaces on the import. See http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/whatsnew.htm#sthref12 for explanations.

There are few setups steps to getting datapump going that you must do on each instance:
1. Create an Oracle directory: create directory dpump_dir1 as '/u01/ dpump'
2. Grant access to the directory: grant read,write on directory dpump_dir1 to dpump_user

Here's a sample export statement:
expdp dpump_user/dpump_pwd_at_mysourcedb SCHEMAS=DAVE DUMPFILE=dave.dmp DIRECTORY=dpump_dir1 logfile=tm_dev.dmp.log

Here's a sample import statement:
impdp dpump_user/dpump_pwd_at_mytargetdb dumpfile=dave.dmp remap_schema=DAVE:JOE remap_tablespace=TS_1:TS_X logfile=IMP.log directory=dpump_dir1 Received on Fri Apr 27 2007 - 13:41:43 CDT