Home » RDBMS Server » Server Administration » temp table + export file size
temp table + export file size [message #52751] Sun, 11 August 2002 06:28 Go to next message
feras
Messages: 9
Registered: September 2000
Junior Member
1-What the use of temporary table+Syntase
2-what the syntase of export to allow me to spacify more than one export file to workaround the 2G size limit

Report message to a moderator

Re: temp table + export file size [message #52766 is a reply to message #52751] Mon, 12 August 2002 08:38 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
temporary table are simply a feature available which can make data processing easier. Are you sure you have a 2BG limit?
http://www.orafaq.net/faqiexp.htm
Recent versions of EXP have FILESIZE parameter.
exp help=y

Report message to a moderator

Re: temp table + export file size [message #52806 is a reply to message #52751] Wed, 14 August 2002 20:14 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
1. For sortings, index creations, when using ORDER BY, DISTICT, etc.

2. Explained in details with code examples Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Re: Unnecessary Indices
Next Topic: More than one database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:59:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.