OraFAQ Forum: Server Utilities » Import to another user

Home » RDBMS Server » Server Utilities » Import to another user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import to another user [message #135642]

Thu, 01 September 2005 11:33

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

I exported user ILLETMENY1 from database. ILLETMENY1 default tablespace is KIR_DATA for tables and KIR_INDX to index.
I created a new user(ILLETMENY2) and tablespaces(KIR_DATA2,KIR_INDX2) in the same database sid.
How can i load dump of ILLETMENY1 TO KIR_DATA2,KIR_INDX2 for ILLETMENY2 user?

Oracle8i Enterprise Edition Release 8.1.7.4.1

Thanks,
Zoltán Patalenszki

Report message to a moderator

Re: Import to another user [message #135648 is a reply to message #135642]

Thu, 01 September 2005 12:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Make sure you have KIR_DATA2 as the default tablespace for ILLETMENY2
Do not grant RESOURCE role to the user.
first do the import only the data

$imp dba/passs fromuser=ILLETMENY1 touser=ILLETMENY2 indexes=n constrains=n

Then extract ddl from the source for indexe or from dumpfile using INDEXFILE option.
Edit the index tablespace to KIR_INDX2.
Run against target.

Else, create indexes along with import (Normal import).
then move those indexes to KIR_INDX2

Report message to a moderator

Re: Import to another user [message #136160 is a reply to message #135642]

Tue, 06 September 2005 07:53

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Hi,

Thanks very much!

Zoltán Patalenszki

Report message to a moderator

Previous Topic:	... Proccesing Exel File. Loading Data.....
Next Topic:	SQL Loader ---One record is missed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 21:54:24 CDT 2024