OraFAQ Forum: Server Administration » Import problem. need help

Home » RDBMS Server » Server Administration » Import problem. need help

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

Import problem. need help [message #175748]

Mon, 05 June 2006 04:05

malkaianil
Messages: 6
Registered: June 2006
Location: bangalore

Junior Member

Hi everybody,

I am facing a problem in importing perticular user from the backup. we everyday take a logical backup using following syntax.

C:\exp system/manager@orcltemp file=f:\full_dump\full.dmp log=f:\full_dump\log.log full=yes

Now one of my user wants his data in the different user of status 20th may 2006. I have the backup and i am trying to import it with following syntax.

C:\imp system/manager@orcltemp file=F:\full_dump\full_20_may06.dmp log=F:\full_dump\full_20_may06.log fromuser=bcentral_pf touser=bcd_pf

Where i have created a new user bcd_pf and granted a dba. bcentral_pf has the complete data which i need to import to bcd_pf. But when i run this syntax it is not importing an objects in return it hangs for few seconds and comes out without importing any objects. If i check the log file does't contain any thing.

I need a help as to how best i can import it.

Regards,
Anil

Report message to a moderator

Re: Import problem. need help [message #175749 is a reply to message #175748]

Mon, 05 June 2006 04:10

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to add FULL=Y to the IMP command.

Report message to a moderator

Re: Import problem. need help [message #175753 is a reply to message #175749]

Mon, 05 June 2006 04:22

malkaianil
Messages: 6
Registered: June 2006
Location: bangalore

Junior Member

Hi,

If i improt with full=yes, objects are getting improted. Even i tried to import the perticualr user on my system using the same syntax but it is not importing here also.

Waiting for your reply

Anil

Report message to a moderator

Re: Import problem. need help [message #175761 is a reply to message #175753]

Mon, 05 June 2006 04:38

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

malkaianil wrote on Mon, 05 June 2006 11:22

If i import with full=yes, objects are getting imported.

If objects are imported (at least, that's what I concluded reading your last post), what's the question? Is there any other problem? Error message? Anything?

Report message to a moderator

Re: Import problem. need help [message #175765 is a reply to message #175748]

Mon, 05 June 2006 04:58

malkaianil
Messages: 6
Registered: June 2006
Location: bangalore

Junior Member

Hi,

If i import with full=y all objects will be imported. Which i don't want. As, the size of the dump file itself is 3.3gb. The total database size is around 28gb. My user wants the objects of his own data in new username. So i created username as bcd_pf and tried to import from it from backup of 20th may 06 of user bcentral_pf to bcd_pf. When i try to import with fromuser and touser the objects are not getting imported. There is no error also. Log file also does't contain any information. So i am not getting what exactly is the problem.

Anil

Report message to a moderator

Re: Import problem. need help [message #175769 is a reply to message #175765]

Mon, 05 June 2006 05:16

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I apologize; it was my mistake - FULL and FROMUSER ... TOUSER parameters can't be used together. My initial idea was completely wrong.

Were export and import done using the same version? Did you, for example, use EXP 9i and IMP 8.1.7?

Report message to a moderator

Re: Import problem. need help [message #175785 is a reply to message #175748]

Mon, 05 June 2006 06:36

malkaianil
Messages: 6
Registered: June 2006
Location: bangalore

Junior Member

The backup is from the same server. So there is no question of migration.

Report message to a moderator

Previous Topic:	Limit max no of user
Next Topic:	Installing Oracle client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:33:38 CDT 2024