Import & NLS_LENGTH_SEMANTICS

I’ve been importing some data from an export of the production 8i instance to a 10g development instance.

This includes some multibyte data (for a little more on that see previous post).

However, if I just import the data then some of the rows are rejected because the length is too long for the column.

This sounds like a NLS_LENGTH_SEMANTICS thing whereby the column definitions of the tables concerned should be CHAR rather than BYTE.

I thought that if I changed the NLS_LENGTH_SEMANTICS setting for the database, then the import might create the tables with CHAR column lengths. But it didn’t, understandably probably.

So, the only alternative seems to be to create an indexfile from the import and edit it so that the column definitions are CHAR. And then manually create them. I need these reverse engineered creation scripts anyway, I suppose.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 75 other followers

%d bloggers like this: