Home » SQL & PL/SQL » SQL & PL/SQL » Help Needed
Help Needed [message #260428] Sun, 19 August 2007 15:56 Go to next message
SamuelJk
Messages: 15
Registered: August 2007
Junior Member
Hi All,

Source Table x having 500 Million Records (Table size 20 GB) Based on X snapshot created in reporting server. (remote)snapshot refresh failed after 3 hours.

Please suggest me why it is fails. And which is the best possible way to get all records in source server table to remote serever.

Thanks
Samuel.
Re: Help Needed [message #260429 is a reply to message #260428] Sun, 19 August 2007 16:16 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Refresh failed.

How do you know it failed? Because, if you know it did fail, how come you don't know why it happened? There was no error message, warning, alert, cry for help ... nothing?
Re: Help Needed [message #262380 is a reply to message #260428] Sun, 26 August 2007 19:02 Go to previous message
SamuelJk
Messages: 15
Registered: August 2007
Junior Member
Hi,

I tried But the sanpshot refresh not competed after 24 HRS and No error.
I want to move all 500 million record from source server to remote server by snapshot.

Thanks
Samuel
Previous Topic: cross tab query problem
Next Topic: day, week, month and year grouping
Goto Forum:
  


Current Time: Fri Dec 09 16:01:01 CST 2016

Total time taken to generate the page: 0.14930 seconds