OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export

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

Export [message #246211]

Wed, 20 June 2007 05:23

mdamjad
Messages: 45
Registered: May 2005

Member

Iam Using Oracle 8.1.5 on windows 2000 professional , My Problem is that the OS is corrupted and is not booting is there any way to export a user from DOS mode

Report message to a moderator

Re: Export [message #246213 is a reply to message #246211]

Wed, 20 June 2007 05:25

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Export, no.
Copy the files, yes.

Regards
Michel

Report message to a moderator

Re: Export [message #246215 is a reply to message #246213]

Wed, 20 June 2007 05:30

mdamjad
Messages: 45
Registered: May 2005

Member

Which file should I copy

Report message to a moderator

Re: Export [message #246223 is a reply to message #246215]

Wed, 20 June 2007 05:57

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

All database related files: data files, redo logs, archived logs, init or spfile, password file.

Regards
Michel

Report message to a moderator

Re: Export [message #246232 is a reply to message #246215]

Wed, 20 June 2007 06:38

mdamjad
Messages: 45
Registered: May 2005

Member

Where should I copy these files

Report message to a moderator

Re: Export [message #246245 is a reply to message #246232]

Wed, 20 June 2007 07:21

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Where you want!? Tape, external disk, floppy disk, USB key...

Regards
Michel

Report message to a moderator

Re: Export [message #246281 is a reply to message #246245]

Wed, 20 June 2007 08:41

mdamjad
Messages: 45
Registered: May 2005

Member

How to Export , After Copying .

Report message to a moderator

Re: Export [message #246286 is a reply to message #246281]

Wed, 20 June 2007 08:47

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You don't export, you copy back your files when your system will be up or on another server (with the same directory tree if possible).
Then use oradim to create a service for your instance and startup.

Regards
Michel

Report message to a moderator

Re: Export [message #246402 is a reply to message #246213]

Wed, 20 June 2007 15:49

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

Senior Member
Account Moderator

I'm sorry if I misunderstood the question and the very first answer, but I'd like to know why is it possible to COPY files using DOS, but impossible to perform EXPORT?

As I understood it, Windows is broken and it won't boot. Fine. So you boot the computer using a bootable floppy disk (for example) and, as soon as you have the command prompt, do something like this:

A:\> set tns_admin = c:\oracle\cfg
A:\> c:\oracle\bin\exp scott/tiger@mydb file=scott.dmp

Wouldn't that work too? /forum/fa/1600/0/

Report message to a moderator

Re: Export [message #246405 is a reply to message #246211]

Wed, 20 June 2007 16:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Wouldn't that work too?
export requires the database to be up & online.
So if the database will start, then export should work.

Report message to a moderator

Re: Export [message #246432 is a reply to message #246402]

Wed, 20 June 2007 23:22

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

LittleFoot,

If I understood clearly his state.
He can't start Windows but has access to DOS (maybe from a rescue disk).
So he can't start the database (which means starting Windows services) but has physical access to the files.
So he can copy/backup/save the files somewhere, in case of a disk format is needed and then restore them after fixing its Windows problem.

Regards
Michel

Report message to a moderator

Re: Export [message #246497 is a reply to message #246432]

Thu, 21 June 2007 02:09

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

Senior Member
Account Moderator

Thank you; I think I got the point.

Report message to a moderator

Previous Topic:	sql loader problem (merged 2 threads)
Next Topic:	Commit in sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 13:53:26 CDT 2024