Toad World® Forums

TOAD- EXPORT


#1

I am actually trying to export almost 7 million rows from a table and while exporting, am using the option “EXPORT IT AS FLAT FILE”

I am trying to generate the ctl, data and spek file . While I am doing it, am getting “OUT OF MEMORY”. Please suggest me what can I do to avoid this error. I was able to do for the other tables and this table doesnot work.

Quick response is appreciated


#2

What version of Toad are you using? I think this was a bug in 10.1 or 10.5, but
it is fixed in 10.6.


#3

I am using 9.6.0 version


#4

Hm , maybe the bug went further back than I thought.

As a workaround, you can use the Grid-> Rt -Click -> “Save as”.
Use the SQL Loader Format. Just make sure “Display all exported results in
grid” is unchecked (if it’s not, you’ll get another out of
memory error).

-John


#5

Have you tried the Save As > SQL Loader feature instead of the Database > Export

Table as Flat file feature?


#6

I logged out and logged in and started new session. It worked when I exported

Thanks,
Pranathi


#7

Can someone please tell me how to change the connection that is attached to a
query? We moved to a different database and the query reverts back to the
original connection. Thanks!

Have DBA on standby and need quick response.

Darlene R. Ulmet

Financial Analyst II

Revenue Cycle

Strategic Financial Planning and Analysis

Baylor Health Care System

Phone: (214) 820-1936

Fax: (214)820-8515

Email: Darlene.Ulmet@BaylorHealth.edu

“It is never too late to become what you might have been.”

George Eliott (Mary Ann “Marian” Evans Lewes Cross)

(1819-1880)


#8

Morning Darlene,

Can someone please tell me how to change the connection that
is attached to a query? We moved to a different database
and the query reverts back to the original connection. Thanks!

I think you might get a better response if you ask on the TDA group
rather than here. Sorry I can’t help. :frowning:

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk