Xref: alice comp.databases.oracle.misc:52407 Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!newsfeed.direct.ca!logbridge.uoregon.edu!cs.utexas.edu!news.cs.utexas.edu!rattlesnake.cs.utexas.edu!sambavan From: Sambavan Tharmarajah Newsgroups: comp.databases.oracle.misc Subject: Re: Newbee req. help with crdb and import. Date: Wed, 2 Feb 2000 21:24:22 -0600 Organization: Computer Sciences, University of Texas Lines: 84 Message-ID: References: <949528316.8854.0.pluto.d4ee154e@news.demon.nl> Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Trace: news.cs.utexas.edu 949548266 19520 128.83.144.158 (3 Feb 2000 03:24:26 GMT) X-Complaints-To: usenet@cs.utexas.edu To: Sybrand Bakker In-Reply-To: <949528316.8854.0.pluto.d4ee154e@news.demon.nl> Yes, I did run the files that you had specified here but don't think in the same order. I think I had the put the catalog.sql and catexp.sql in the crdb and ran the catproc.sql later. Should it be in the same sequence as catalog.sql catproc.sql catexp.sql If this is the case, can I shut down the database remove all the corresponding .dbf files and control files and re-run the crdb once again with all the script files put in, and try re-importing the datafiles. If I have to follow the same sequence as you have specified here can I run these scripts in crdb under system/manager connect internal ...../catalog.sql ...../catproc.sql ...../catexp.sql Could you pl. advise on this. On Wed, 2 Feb 2000, Sybrand Bakker wrote: > 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 > > > > -------------------------------------------------------- > > > > > Sam .T ------------------------------------------------------- What I do today is important because I'm exchanging a day of my life for it --------------------------------------------------------