Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2006
    Location
    Mumbai, India
    Posts
    26

    Question Unanswered: SQLPLUS login information?

    I am using IBM AIX 5.3 operating system.
    From which file the information after the sqlplus login-in comes.

    For example, I would like to know the source file of following bold lines,

    /home/oracle>sqlplus

    SQL*Plus: Release 9.2.0.6.0 - Production on Mon Dec 17 23:38:02 2007

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: /as sysdba

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.6.0 - Production

    SQL>
    *********************************************
    God Bless You.

  2. #2
    Join Date
    Nov 2007
    Location
    Connecticut
    Posts
    40
    select * from v$version;

  3. #3
    Join Date
    Aug 2006
    Location
    Mumbai, India
    Posts
    26
    I do not want any view name, but I want physical filename fromwhere this message is picked up run time.
    *********************************************
    God Bless You.

  4. #4
    Join Date
    Nov 2007
    Location
    Connecticut
    Posts
    40
    There is no physical file name from where this info is picked up (what would make you think that there is a physical file?) That's quite an assumption as well as bad design -- That's why we use databases -- to avoid tediousness of working w/ physical files. --

    If your designing a system, would you choose to store info in a flat file or a database -- ? If your thinking flat file, you need to brush up on basic db design.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, if we had to bet on that, I'd put my money on the 'SYSTEM01.DBF' physical file.

  6. #6
    Join Date
    Nov 2007
    Location
    Connecticut
    Posts
    40
    I'd put serious $$$ on that info not being in system01.dbf :-)
    Code:
    select * from client where clue > 0;
    0 rows returned

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    It's actually kind of funny.

    v$version is a synonym for sys.v_$version, which is a view.

    The select contained in the view is

    SELECT "BANNER" FROM V$VERSION;

    Which makes it kind of circular and borders on magic.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    OK, here's why I'd put my money on system01.dbf (or its derivations): every Oracle database contains a tablespace named SYSTEM which always contains data dictionary tables. It is created automatically during database creation time and, as it is the very first tablespace in an Oracle database, Oracle automatically allocates the first datafiles for the SYSTEM tablespace.

    Furthermore, a small database might need only the SYSTEM tablespace (although it is recommended to create additional tablespaces for storing data, temporary tablespace etc.). In that case (a small database having only the SYSTEM tablespace), there's nothing else than this one, single datafile so - I believe that banner must be somewhere in there. Not really viewable via Notepad or vi, but nevertheless.

    Now, I'd like to hear what you think about it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •