Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> unable to create data dictionary views
Hi,
although I got the right hint from this group I'm still not able to
create my dictionary views. Can somebody help me please:
- @dbmsstdx.sql seems to work alright (I connect as user SYS)
I create my database this way:
create database VIS1 logfile group 1 ('oit1log11.log', 'oit1log12.log') size 50K, group 2 ('oit1log21.log', 'oit1log22.log') size 50K datafile 'oit1_00.dbf' size 10M maxlogfiles 5 maxloghistory 100 maxdatafiles 10 maxinstances 2 archivelog ;
I also created some more rollback segments and another tablespace and
some more logfiles.
and they are vieable by using
select member from sys.v$logfile; select name from sys.v$datafile; select name from sys.v$controlfile;
Thanks for any help
mailto:Peter.Schupp_at_object-it.de
STZ object-IT
Postfach 10 43 62
D-70038 Stuttgart
PGP Key available at: http://wwwkeys.de.pgp.net