SELECTs of Columns in SQL*Plus Displayed too Wide for database 9.2
(Doc ID 272010.1)
Last updated on APRIL 01, 2021
Applies to:
SQL*Plus - Version 9.2.0.1 to 9.2.0.4 [Release 9.2]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
Selects of Columns in Sqlplus displayed too wide for database 9.2.
Exported from the 8.1.7.3 (WE8ISO8859P1) database, and imported that into a new 9.2.0.4 (UTF8) database.
Now when you select columns like tablespace_name (or from dba_rollback_segs, etc) in SqlPlus, the returned column value stretches across the 80 columns of screen (instead of just occupying the 30 characters it did under 8.1.7.3).
A desc of dba_tablespaces shows that the column length is set to 30 only:
TABLESPACE_NAME NOT NULL VARCHAR2(30)
Changing pagesize and linesize didn't help.
Explicitly setting the column format to A30 worked, but this should not be required since the column width is actually 30 only.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |