Home » SQL & PL/SQL » SQL & PL/SQL » Extract data (Oracle 10g)
Extract data [message #343200] Tue, 26 August 2008 11:07 Go to next message
uicmxz
Messages: 48
Registered: July 2006
Member
How to provide the estimate sizing for different objects in query to do right full file estimate for data extract?
Re: Extract data [message #343240 is a reply to message #343200] Tue, 26 August 2008 13:36 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Considering the amount of information you gave I would probably roll a D20 and a D10 and multiply the results.

Then add a "Bytes", "KB", "MB", "GB" according to the result of a D4 roll.

Otherwise it depends on what sort of "data extract" you actually talk about. DataPump for example has an estimate only option.
Re: Extract data [message #343258 is a reply to message #343240] Tue, 26 August 2008 15:24 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Somehow, if we can only integrate the D6 and D8 in there too.
Re: Extract data [message #343272 is a reply to message #343258] Tue, 26 August 2008 16:28 Go to previous messageGo to next message
uicmxz
Messages: 48
Registered: July 2006
Member
Could you please give me the example?
Re: Extract data [message #343375 is a reply to message #343272] Wed, 27 August 2008 01:40 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you follow the link you were given?
What part did you not understand?
Try to learn to code from DOCS instead of examples.
Re: Extract data [message #343564 is a reply to message #343375] Wed, 27 August 2008 09:23 Go to previous messageGo to next message
uicmxz
Messages: 48
Registered: July 2006
Member
Oracle Data Pump is a new feature of Oracle Database 11g. We are in 10g.
Re: Extract data [message #343565 is a reply to message #343564] Wed, 27 August 2008 09:27 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
uicmxz wrote on Wed, 27 August 2008 15:23
Oracle Data Pump is a new feature of Oracle Database 11g. We are in 10g.


Then you need the D15 switch in the controller set to 42
Previous Topic: ORA-01410: invalid ROWID
Next Topic: INSERT TIME
Goto Forum:
  


Current Time: Sat Dec 10 18:22:44 CST 2016

Total time taken to generate the page: 0.06998 seconds