OraFAQ Forum: Server Utilities » Import in windows

Home » RDBMS Server » Server Utilities » Import in windows (Windows XP)

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

Import in windows [message #375953]

Mon, 15 December 2008 07:40

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I have the FULL EXPORT backup at the UNIX box but it is with extention FULL_EXP.dmp.gz it means it is gunzipped.

And suppose i want it to import that file it in windows then does it works for me?

I think no.

Please explain me.

Thanks,

Report message to a moderator

Re: Import in windows [message #375955 is a reply to message #375953]

Mon, 15 December 2008 07:45

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

The file is compressed. You need to uncompress it before you can import the dump. Something like WinZip will work well.

Report message to a moderator

Re: Import in windows [message #376070 is a reply to message #375953]

Mon, 15 December 2008 22:50

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

But i read somewhere on net that we need to go for EXPDP and IMPDP instead of FULL export by - EXP

And Compressed file in unix will not work in the windows even if it will uncompressed?
Is it true?

Thanks,

[Updated on: Mon, 15 December 2008 22:55]

Report message to a moderator

Re: Import in windows [message #376073 is a reply to message #376070]

Mon, 15 December 2008 23:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

expdp/impdp does not exist in 9i.
Wrong.

You misread what is somewhere in the net... like you misread the subtitle of forums, at almost 300 posts you should choose the correct forum.

Regards
Michel

Report message to a moderator

Re: Import in windows [message #376090 is a reply to message #375953]

Tue, 16 December 2008 00:32

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Thanks for your information.

I would like to know while importing the database into windows which basic things i need to do in windows database?

1. User creation script ????
2. Tablespace creation script???
3. ?????? - tell me if any

Does those required if i would be using EXPDP/IMPDP???

Thanks,

Report message to a moderator

Previous Topic:	user rules
Next Topic:	SQL loader cannot check for nulls

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 20:07:58 CST 2024