>"I have two machines on which I have Redhat 7,3 and Oracle 9i rel. 2. I
have
>been successful in the past creating a database with no datafiles and then
>connecting it using Enterprise Manager Console."


You have possibly stated something incorrectly. You cannot create a
database without datafiles. First of all
their has to at least be a system tablespace and it's associated datafiles
and one rollback segment in the
RBS tablespace and it's associated datafiles.

So how did you create a database that you connected to without having these
tablespaces.




Dionne Whitaker-Moore
Senior Oracle DBA
ofc -703-866-4000 ext 610
...Knowledge is Contagious Spread the INFECTION

Oracle LazyDBA home page