Join us at the Everyday AI Conference in London, New York & Bengaluru! REGISTER NOW

How to Change Oracle Data Storage Type

Solved!
jhiatt09
Level 1
How to Change Oracle Data Storage Type

I'm hoping to use the VARCHAR2 column storage type in Oracle rather than NVARCHAR2, which appears to be the default storage type used by Dataiku for strings in Dataiku-managed datasets stored in Oracle. What's the best way to do this?

0 Kudos
1 Solution
pmasiphelps
Dataiker
Dataiker
Hi,
 
As a one-off workaround, in your output dataset (stored in Oracle), go to Settings -> Advanced -> Table creation mode -> Manually define
 
image (8).png
 
You can then manually change the column storage types in this field.
 
You can find/replace all instances of "NVARCHAR2" with "VARCHAR2" by:
  1. Type "CTRL + OPTION + F" in your keyboard. A find/replace box will pop up. Enter "NVARCHAR2" here, then hit the enter key: 
     

    image (9).png

  2. Write "VARCHAR2" in the "with" field, then hit the enter key: 
     

    image (10).png

  3. Then choose replace "All": 
     

    image (11).png

Now your dataset should have column data types of "VARCHAR2". 
 

image (12).png

 

Best,

Pat

View solution in original post

0 Kudos
2 Replies
Clément_Stenac
Dataiker
Dataiker

Hi,

It's not possible to change this. We use NVARCHAR2 since it can accomodate all characters, which is not the case of VARCHAR or VARCHAR2. 

 

We'd be interested in hearing more about your use case for using VARCHAR2.

0 Kudos
pmasiphelps
Dataiker
Dataiker
Hi,
 
As a one-off workaround, in your output dataset (stored in Oracle), go to Settings -> Advanced -> Table creation mode -> Manually define
 
image (8).png
 
You can then manually change the column storage types in this field.
 
You can find/replace all instances of "NVARCHAR2" with "VARCHAR2" by:
  1. Type "CTRL + OPTION + F" in your keyboard. A find/replace box will pop up. Enter "NVARCHAR2" here, then hit the enter key: 
     

    image (9).png

  2. Write "VARCHAR2" in the "with" field, then hit the enter key: 
     

    image (10).png

  3. Then choose replace "All": 
     

    image (11).png

Now your dataset should have column data types of "VARCHAR2". 
 

image (12).png

 

Best,

Pat

0 Kudos