Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import issue
On Apr 27, 3:41 pm, treschau..._at_yahoo.com wrote:
> 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. Seehttp://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/w...
> 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
Hi,
yes, I believe data pump will be the solution for my problem, altough
I never worked with it before, don't know if this works fine with
lobs, but unfortunately this db is oracle 9i
thanks for your reply
sam
Received on Fri Apr 27 2007 - 14:43:42 CDT