OraFAQ Forum: Backup & Recovery » how can i use BAK and TRN files

Home » RDBMS Server » Backup & Recovery » how can i use BAK and TRN files

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

how can i use BAK and TRN files [message #266415]

Mon, 10 September 2007 16:50

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

hi all
i have files (BAK ,TRN ) from sql server 2000 .
how can i use this this to read data and put this data in
Oracle Database 10g?
Thax
Rafeek

Report message to a moderator

Re: how can i use BAK and TRN files [message #266416 is a reply to message #266415]

Mon, 10 September 2007 16:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i have files (BAK ,TRN ) from sql server 2000 .
>how can i use this this to read data and put this data in Oracle Database 10g?
AFAIK, you can't read either files types directly.

Report message to a moderator

Re: how can i use BAK and TRN files [message #266494 is a reply to message #266416]

Tue, 11 September 2007 00:41

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

how can i read data in this files i have SQL sever 2000 on windows 2000 pro

Report message to a moderator

Re: how can i use BAK and TRN files [message #266495 is a reply to message #266415]

Tue, 11 September 2007 00:44

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Anacedent answered you you can't use it directly.

You have to convert it (like in .csv format) and then use SQL Loader.

Report message to a moderator

Re: how can i use BAK and TRN files [message #266497 is a reply to message #266415]

Tue, 11 September 2007 00:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how can i read data in this files i have SQL sever 2000 on windows 2000 pro
By using SQL Server 2000 & convert the files to ASCII, CSV, or more inter-operable format.

Report message to a moderator

Re: how can i use BAK and TRN files [message #266717 is a reply to message #266495]

Tue, 11 September 2007 08:42

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

how can convert it to like in .csv format ?

Report message to a moderator

Previous Topic:	My oracle cannot start, requires data recovery .
Next Topic:	help me with restore problem..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 05:31:32 CDT 2024