troubleshooting Question

Convert Oracle 12c Tables from BYTES to CHAR

Avatar of Bally Jassal
Bally Jassal asked on
DatabasesOracle Database
2 Comments1 Solution77 ViewsLast Modified:
Convert Oracle 12c Tables from BYTES to CHAR
I want the tables be converted from BYTE to CHAR on 12.1.0.
I am doing a export dump from a non-Unicode database and the Varchar2 data types is in BYTES (Which is the default).
The import I am doing on is a UNICODE database but import dump is Keeping the same data type as in the source.
Is there a way to change the NLS_LENGTH_SEMANTICS set as CHAR and do the export?
or ; I have to change the NLS_LENGTH_SEMANTICS to CHAR on the target as well?
I am not sure if this will work?

Source:=
SQL> desc PS_GVT_POI_TBL
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- ------------------
SETID                                                                               NOT NULL VARCHAR2(5)
GVT_POI                                                                             NOT NULL VARCHAR2(4)

The result I am looking should look like this (below):=
SQL> desc PS_GVT_POI_TBL
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- ------------------
 SETID                                                                               NOT NULL VARCHAR2(5 CHAR)
 GVT_POI                                                                             NOT NULL VARCHAR2(4 CHAR)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros