Re: sort-of-simple Oracle questions

Steve Parker <steve_at_naweb.com> wrote:

>hello all,
>
>I running Oracle 8.0.5 on Linux...
>
>I have a few questions i hope somebody could help me with:
>
>1. Can a field in a table be a list of items (i.e., field EMAIL of
>table CUSTOMER contains a list of all email addresses the customer
>has)? Or, must you use a different table to encompas this info in the
>design?
>
>

In 8i there can be fields that are, in essence, tables...I don't think this was implemented in 8.0...

>
>2. Is there a SQL command to simply view the current tables that exist
>in a tablespace - just thier names... or a tool that can do it
>(sqlplus, svrmgrl, ect)
>

in Sqlplus or svrmgrl:
select table_name from sys.dba_tables where tablespace_name = <your tablespace name goes here>
>
>3. What useful log files are there? I know about listener.log which
>logs connection attemts to the Oracle listener, but what about logs for
>interaction with the database itself (i.e., record failed SQL attempts,
>ect...)
>

Check sqlnet.log, alert.log, and others (I'm sure you'll get more from others )
>
>Any help with these oddly dispersed questions would be greatly
>appreciated.
>
>thanks,
>steve

hth
John Greco

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Nov 10 1999 - 12:52:35 CST