Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

insert and delete

just a DBAFeb 26 2013 — edited Feb 27 2013
I would like to clarify the situation.

1. create table t1 as select * from t2.
2. delete from t1.

Why second statement is several times slower than insert if it just moves the same amount of data into undo segments ?
This post has been answered by Jonathan Lewis on Feb 27 2013
Jump to Answer

Comments

InoL

I do not know anything about BI Publisher, but I assume it has an option to send the output to a printer. Simply Googling for it:
Configure a Printer in Oracle Analytics Publisher
Browsers cannot send output directly to a printer. There is always some user interaction before sending the output to a printer.

Small print: there is a non-standard way to send some output directly to the printer from a browser. However, it involves hacking the Windows registry (I only know this trick for Windows):
Create a PDF file with extension .pdfp. Windows doesn't know this extension, so it will create a new registry entry for pdfp.
Change the Open behaviour in the registry (find it somewhere in \HKEY_CURRENT_USER\SOFTWARE). Instead of opening the file, print it. In my case, I use Sumatra pdf:

"C:\Users\someuser\AppData\Local\SumatraPDF\SumatraPDF.exe" -print-to-default "%1" %*

Of course, this command will change per configuration.

TexasApexDeveloper

If the print engine was NOT Bi Publisher, I'd recommend Apex Office Print. They have functionality to print to a network printer included with the product. Since this is a Bi Publisher question, you MIGHT get a better response if you posted it to that products support forum..
Thank you!
Tony Miller
White Rock, NM

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2013
Added on Feb 26 2013
10 comments
700 views