Home » RDBMS Server » Backup & Recovery » how can i use BAK and TRN files
how can i use BAK and TRN files [message #266415] Mon, 10 September 2007 16:50 Go to next message
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
Re: how can i use BAK and TRN files [message #266416 is a reply to message #266415] Mon, 10 September 2007 16:57 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: how can i use BAK and TRN files [message #266494 is a reply to message #266416] Tue, 11 September 2007 00:41 Go to previous messageGo to next message
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
Re: how can i use BAK and TRN files [message #266495 is a reply to message #266415] Tue, 11 September 2007 00:44 Go to previous messageGo to next message
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.
Re: how can i use BAK and TRN files [message #266497 is a reply to message #266415] Tue, 11 September 2007 00:48 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: how can i use BAK and TRN files [message #266717 is a reply to message #266495] Tue, 11 September 2007 08:42 Go to previous message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
how can convert it to like in .csv format ?
Previous Topic: My oracle cannot start, requires data recovery .
Next Topic: help me with restore problem..
Goto Forum:
  


Current Time: Sun Dec 04 08:43:27 CST 2016

Total time taken to generate the page: 0.07383 seconds