Home » RDBMS Server » Server Utilities » how to find the size of the given file in SQL*LOADER
how to find the size of the given file in SQL*LOADER [message #173730] Wed, 24 May 2006 04:20 Go to next message
sam_dinesh
Messages: 18
Registered: February 2006
Location: india
Junior Member
I want to find out the size of the given data file and i have to insert that size in a table.is there any option.pls help me

Report message to a moderator

Re: how to find the size of the given file in SQL*LOADER [message #173773 is a reply to message #173730] Wed, 24 May 2006 06:57 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There is no native method within sqlldr.
You have to find the size of file using OS commands and pass it into the control file (sqlldr control file) as a 'constant'.
Search the forum for more examples.
With little scripting, this can be easily done.

Report message to a moderator

Previous Topic: SQL*LOADER,IMPORT/EXPORT from Client mechine
Next Topic: how to export my tables in database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 01:10:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.