Operating System - HP-UX
1748272 Members
4316 Online
108760 Solutions
New Discussion юеВ

Re: select from v$controlfile truncated

 
SOLVED
Go to solution
Enrico Venturi
Super Advisor

select from v$controlfile truncated

Hello colleagues,
I'm using ORACLE 8 database;
I run sqldba then I select the content of v$controlfile view....
the result is truncated (!!) to 80 chars ...

probably I've to set some parameter to get the proper result (the NAME attribute is 513 chars long)

What's the command to resize the output of sqldba select?

thanks a lot
Enrico
8 REPLIES 8
Alex Lavrov.
Honored Contributor
Solution

Re: select from v$controlfile truncated

SQL> set linesize 1000

It should help.
I don't give a damn for a man that can only spell a word one way. (M. Twain)
Enrico Venturi
Super Advisor

Re: select from v$controlfile truncated

mmmhhh ....
MGR-00110: illegal SET option
I'm running sqldba ...
Alex Lavrov.
Honored Contributor

Re: select from v$controlfile truncated

WEll, it's working in SQLPlus .... I always used it, when I worked with ORACLE ...

http://www.adp-gmbh.ch/ora/sqlplus/linesize.html
I don't give a damn for a man that can only spell a word one way. (M. Twain)
Jean-Luc Oudart
Honored Contributor

Re: select from v$controlfile truncated

sqldba !
I thought this was gone long time ago !

You should use the tools/utilities provided with same version.

Regards
Jean-Luc
fiat lux
Alex Lavrov.
Honored Contributor

Re: select from v$controlfile truncated

If you want to use ome fance GUI for ORACLE, try TOAD, very cute tool.


http://www.quest.com/toad/index.asp




I don't give a damn for a man that can only spell a word one way. (M. Twain)
Alex Lavrov.
Honored Contributor

Re: select from v$controlfile truncated

* " some fancy GUI "

laptop keyboard ....


I don't give a damn for a man that can only spell a word one way. (M. Twain)
TwoProc
Honored Contributor

Re: select from v$controlfile truncated

Sqldba - didn't that go out in the earliest versions of 7.0? If you're on version 8 - try "svrmgrl". If you're on version 8i or later, you should use sqlplus "/ as sysdba" from the logon that owns the database - which is probably "oracle".
We are the people our parents warned us about --Jimmy Buffett
Yogeeraj_1
Honored Contributor

Re: select from v$controlfile truncated

hi,

are you using sqlplus?
set linesize should correct the problem

are you using a microsoft windows client?

let us know.

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)