topic Re: select from v$controlfile truncated in Operating System - HP-UX

select from v$controlfile truncated

Enrico Venturi — Mon, 07 Mar 2005 07:12:15 GMT

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

Re: select from v$controlfile truncated

Alex Lavrov. — Mon, 07 Mar 2005 07:15:40 GMT

SQL> set linesize 1000

It should help.

Re: select from v$controlfile truncated

Enrico Venturi — Mon, 07 Mar 2005 07:17:01 GMT

mmmhhh ....
MGR-00110: illegal SET option
I'm running sqldba ...

Re: select from v$controlfile truncated

Alex Lavrov. — Mon, 07 Mar 2005 07:24:02 GMT

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

http://www.adp-gmbh.ch/ora/sqlplus/linesize.html

Re: select from v$controlfile truncated

Jean-Luc Oudart — Mon, 07 Mar 2005 08:21:33 GMT

sqldba !
I thought this was gone long time ago !

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

Regards
Jean-Luc

Re: select from v$controlfile truncated

Alex Lavrov. — Mon, 07 Mar 2005 08:25:47 GMT

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

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

Re: select from v$controlfile truncated

Alex Lavrov. — Mon, 07 Mar 2005 08:27:18 GMT

* " some fancy GUI "

laptop keyboard ....

Re: select from v$controlfile truncated

TwoProc — Mon, 07 Mar 2005 08:40:16 GMT

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".

Re: select from v$controlfile truncated

Yogeeraj_1 — Mon, 07 Mar 2005 09:15:39 GMT

hi,

are you using sqlplus?
set linesize should correct the problem

are you using a microsoft windows client?

let us know.

regards
yogeeraj