help needed triming varchar2 columns
From: David Blocher <dblocher_at_prolog.net>
Date: 1996/07/21
Message-ID: <4stgjo$bge_at_ns2.ptd.net>#1/1
Date: 1996/07/21
Message-ID: <4stgjo$bge_at_ns2.ptd.net>#1/1
We are running Oracle 7.0.12 and we expported our database to reorganize the
extents. While doing so we changed the char columns to varchar2. The problem
is that when we imported the data all of our varchar2 coulums were padded with
trailing blanks. Is there an option with an import utility so the columns
will not be padded. Or does the export utility have some way to remove
trailing blanks on varchar2. I find it odd that switched to varchar2 to get
variable lengths, but the import utility made every column max length. Any
help would be greatly appreciated.
David Blocher
dblocher_at_prolog.net
Received on Sun Jul 21 1996 - 00:00:00 CEST