Re: DBA_USERS: duplicated rows.

It wouldn't work. The first statement is create tablespace system and almost all other statements are create table statements. If you really plan to do that, you need to export your database, destroy the existing database, create a new one, and import your data. If Jerry's suggestions are correct -and they most likely are- you will have your problem back, because your problem is in the data, not in Oracle. If you don't want to follow Jerry's advise, select directly from user$ to see where the differences are between this table and the dba_users view. I would like to advise to be very careful with catalog.sql and sql.bsq. You could easily screw up your complete database. If this would have been a real bug, it would have shown up long ago, don't you think?

Finally a more general remark to everyone: would you be very careful with cross-posting. More and more people in both newsgroups crosspost all their posts. In Europe, local phone calls are not free. Also, it may make some people monitoring both newsgroups, using Outlook, which doesn't seem to filter out the crossposts, respond multiple times.

Hth,

Sybrand Bakker, Oracle DBA

Kekko <dini.f_at_adr.it> wrote in message news:3784CBA8.6A30C66C_at_adr.it...
> I would know if I can execute newly SQL.BSQ ?
>
>
> Jerry Gitomer wrote:
>
> > Hi,
> >
> > When you run the query to display the information from the view
concatenate
> > each column with leading and trailing special characters so you can see
if
> > there are any leading or trailing non-printing characters or spaces in
the
> > names. e.g;
> >
> > SELECT '&'||owner||'&'||table_name||'&' FROM ....
> >
> > regards
> > Jerry Gitomer
> > ---------------------------------------------
> >
> > Kekko wrote in message <377C6C5D.BA364B25_at_adr.it>...
> > >I still continue to have a problem with the dba_users view: it has
> > >duplicated rows. I recreated it but the problem isn't resolved. Than I
> > >modified the creaption script in the catalog.sql: I specified the
select
> > >distinct.
> > >Oracle 8.0.5
> > >Digital UNIX 4.0d
> > >Digital Alpha Server 2100
> > >
> > >Thank you very much.
> > >
> > >Kekko
> > >
> > >
>
Received on Thu Jul 08 1999 - 16:48:37 CDT