Xref: alice comp.databases.oracle.misc:52395 Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!news-MUC.ecrc.net!newsfeed.tli.de!newsfeed2.news.nl.uu.net!sun4nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.misc Subject: Re: Newbee req. help with crdb and import. Date: Wed, 2 Feb 2000 22:49:48 +0100 Message-ID: <949528316.8854.0.pluto.d4ee154e@news.demon.nl> References: Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 949528316 pluto:8854 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@nl.demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 48 The views your are missing are created using catalog.sql The correct sequence is catalog.sql catproc.sql, you may also want to run catexp.sql Hth, -- Sybrand Bakker, Oracle DBA Sambavan Tharmarajah wrote in message news:Pine.LNX.4.21.0002021343000.14730-100000@mamba.cs.utexas.edu... > > Could anyone help me out in creating a database and importing the .dmp > file into it? > > I created a database instance using crdb on Oracle 8.0.5 and then I did a > FULL import of data that I had earlier exported from the Oracle V.7.3.2. Then > when I tried to loged in as a system/manager and tried doing > > select * from user_tables; > > I received an error of DBMS_STANDARD. To correct this I loged in as the > svrmgrl and did a connect internal and then ran the catproc script. After > doing this, I once again loged in as a system and tried running the above > querry and now I get the error message of table or views does not > exist. So I went back and checkd the DBA_TABLES and notice that some of > the table names to be missing. So I thought of checking whether I could > querry those table that exist in the database. When I tried to do a > select on the existing (on DBA_TABLES) table, I get the same error > message. > > So in this case could any one tell me what i'm missing or forgetting to > do. I beleive that importing from lower to the higher version should not > cause any problem. Could some one explain me the right things I show do? > > Thanx, > Sam .T > > ------------------------------------------------------- > > What I do today is important because > I'm exchanging a day of my life for it > > -------------------------------------------------------- >