Yes I can run the update for this particular field.. But I'm importing a few more tables from SQL Server to Oracle & they have lot more character fields with...

There is 15627 rows and select datalength(weight) from trlc - query returns 0 for all the rows..

Thanks Steve. But if there is a space in the csv file, then isn't a space considered as a byte?

Record from TRLC.csv:

11032|100|Wman| | |2008-02-08| |

In the SQL Server database,...

Hi Steve,

Both 'select len(weight) from trlc' & select datalength(weight) from trlc' return 0 in SQL server..

You are right, Steve. I can see the space in text editor.. I need to import this table into Oracle database I'm using SQl Loader:

TRLC.ctl:

load data

infile 'trlc.csv'

...

Thanks so much.

Hi friends,

We have created LInked server to oracle database and have synonyms created for few Oracle tables(example - tablename@link) in the SQL database to access from the...

Oh okay. I created the linked server as below for all the local SQL server logins:

EXEC sp_addlinkedserver

'linkserv', 'Oracle',

'ORAOLEDB.ORACLE', 'oradb'

EXECUTE sp_addlinkedsrvlogin @rmtsrvname='linkserv',

@useself='false', @rmtuser='orauser', @rmtpassword='orapwd'

Created...

We are having issues with the insert statement from the application.. Selects work fine though..

I restarted the db server and ran the select statement again.. I get a different error now

SELECT * FROM

OracleLinkedServer..ouser1.table1

OLE DB provider "ORAOLEDB.ORACLE" for linked server "Linkedservertest" returned message...

Thanks

I tried float(126) I get the below error...

Column or parameter #12: Specified column precision 126 is greater than the maximum precision of 53.

Is there an equivalent for...

Thanks Lowell.

Is 'ProdServer' linkedserver name in the example?

Can you please provide me an example of bcp export and import.. I google'd some examples but they all reference exporting single table but not the full database..

Thank you so...

Thanks everyone.

Yes.. Our client sent a sql file with bunch of insert statements and I had to split the files to run in the query.. I thought BCP utility...

Thanks.

We now generated a script with 'data' from SQL server 2008. I'm trying to run this script against our 2005 database, but I'm not able to copy & paste...