OraFAQ Forum: Server Utilities » Counting the position of data in fixed format.

Home » RDBMS Server » Server Utilities » Counting the position of data in fixed format. (Oracle 9i.0.2, Windows. )

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Counting the position of data in fixed format. [message #474333]

Sun, 05 September 2010 14:18

muktha_22
Messages: 337
Registered: December 2009

Senior Member

Hi,

How the people in production counts the exact position of the data in fixed format of Sql*loader?
Isn't it critical especially in a critical and having many column to be inserted.

Thanks in advance

Report message to a moderator

Re: Counting the position of data in fixed format. [message #474334 is a reply to message #474333]

Sun, 05 September 2010 14:28

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>How the people in production counts the exact position of the data in fixed format of Sql*loader?
Base10 is what most folks use

>Isn't it critical especially in a critical and having many column to be inserted.
Only when you want it to actually load data correctly.

Report message to a moderator

Counting the position of data in fixed format. [message #474336 is a reply to message #474333]

Sun, 05 September 2010 14:49

muktha_22
Messages: 337
Registered: December 2009

Senior Member

Hi,

In production which method the DBA use to counts the exact character position (other than manually counting) of "fixed format data" in Sql loader.

Especially in the case of many column's and having lot of spaces between the column's data?

Thanks in advance

Report message to a moderator

Re: Counting the position of data in fixed format. [message #474337 is a reply to message #474336]

Sun, 05 September 2010 15:00

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>In production which method the DBA use to counts the exact character position (other than manually counting) of "fixed format data" in Sql loader.
I give up.
How do YOU count some thing, other than by COUNTING them?
COUNTING them is faster than trail & error guessing.
You could always use a fixed sized font (10 pitch) & measure the distance between adjacent columns

Report message to a moderator

Re: Counting the position of data in fixed format. [message #474341 is a reply to message #474337]

Sun, 05 September 2010 15:10

muktha_22
Messages: 337
Registered: December 2009

Senior Member

Hi Blackswan,

Thanks a lot

Report message to a moderator

Re: Counting the position of data in fixed format. [message #474343 is a reply to message #474341]

Sun, 05 September 2010 15:34

cookiemonster
Messages: 9169
Registered: September 2008
Location: Rainy Manchester

Senior Member

Well there is an alternative to counting:
If the person who created the file in the first place made a note of the length of each column, then they could just tell whoever is trying to load it.

There's no clever trick if that's what you're looking for.

Report message to a moderator

Re: Counting the position of data in fixed format. [message #474353 is a reply to message #474343]

Sun, 05 September 2010 16:02

muktha_22
Messages: 337
Registered: December 2009

Senior Member

Alright....

Report message to a moderator

Previous Topic:	How to read an Oracle DMP file
Next Topic:	Need to know how long export takes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 20:04:04 CDT 2013

Total time taken to generate the page: 1.14001 seconds