Database Administration (MOSC)

MOSC Banner

expanding a column defined as varchar2(250 char)

edited Jul 7, 2016 5:03AM in Database Administration (MOSC) 6 commentsAnswered

Oracle 11.2.0.4

I have a requirement to expand a column from 250 Unicode characters to 1000 Unicode characters; the column does contain a value.

Here is the table definition:

[Code]

Columns
NAME                            DATA TYPE             NULL  DEFAULT    COMMENTS
*CONTRACT_NBR                   NUMBER                No                  
VEHICLE_DISPOSITION_NBR        NUMBER                No    0             
QUANTITY_ENTRY_NBR             NUMBER                No    0             
SETTLEMENT_NBR                 NUMBER                No    0             
TRADE_BLOTTER_NBR              NUMBER                No    0             
VEHICLE_STORAGE_NBR            NUMBER                No    0             
TEMPORARY_STORAGE_NBR          NUMBER                No    0             
BATCH_NBR                      NUMBER                No    0             
ADVANCE_NBR                    NUMBER                No    0             
MAX_DPR_DATE                   DATE                  Yes                 
DPR_TRANSACTION_NBR            NUMBER                No    0             
DEBIT_CREDIT_NBR               NUMBER                No    0             
WASH_NBR                       NUMBER                No    0             
ACCRUAL_NBR                    NUMBER                No    0             
ACCRUAL_INVOICE_NBR            NUMBER                No    0             

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center