Home » Developer & Programmer » Reports & Discoverer » Exporting Db tables to file and Import from Report Builder (oracle 10g,reports builder 6i)
Exporting Db tables to file and Import from Report Builder [message #430091] Sun, 08 November 2009 03:10 Go to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

Hello,,

Am facing a problem in running a report.Its taking so much time.
Well at times its getting hang and needs to be closed.Can u please tell me exporting Db tables to file and Import from Report Builder.

I have seen that in .net.so please tell me..
Re: Exporting Db tables to file and Import from Report Builder [message #430095 is a reply to message #430091] Sun, 08 November 2009 05:29 Go to previous messageGo to next message
Littlefoot
Messages: 20825
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you should tune the report's query. Because, you can create a flat file by spooling result of a query, but - if it is the same query, it won't be any faster. Furthermore, I have no idea whether it is possible to load such a file into a report. Even if you could do that, it would be unformatted.
Re: Exporting Db tables to file and Import from Report Builder [message #430096 is a reply to message #430095] Sun, 08 November 2009 05:32 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

u can see my post in sql/plsql forum in orafaq.

http://www.orafaq.com/forum/t/152019/124185/

And also please tell me regarding that,

Its taking too much time.Am really cant do anything..

Please help me
Re: Exporting Db tables to file and Import from Report Builder [message #430152 is a reply to message #430096] Mon, 09 November 2009 04:25 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
seyed456 wrote on Sun, 08 November 2009 05:32
u can see my post in sql/plsql forum in orafaq.

http://www.orafaq.com/forum/t/152019/124185/

And also please tell me regarding that,

Its taking too much time.Am really cant do anything..

Please help me


How it would be an reply for Littlefoot`s respons.

Quote:
Hello,,

Am facing a problem in running a report.Its taking so much time.
Well at times its getting hang and needs to be closed.Can u please tell me exporting Db tables to file and Import from Report Builder.

I have seen that in .net.so please tell me



i did n`t get you properly..@ what stage you want to import..and why you want to import...


Do you mean, you want to access the "Exported" file.?Are you want the table list from report builder?

Sriram
Re: Exporting Db tables to file and Import from Report Builder [message #430340 is a reply to message #430096] Tue, 10 November 2009 02:42 Go to previous message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

If you have any plans ahead and suits with you u can simply create .CSV file as told by above gurus. It will be bit faster and avoid your hang and close.


Jak
Previous Topic: Dont wants to show certain matrix columns
Next Topic: End user access to a respective report
Goto Forum:
  


Current Time: Tue Sep 27 00:46:06 CDT 2016

Total time taken to generate the page: 0.31586 seconds