> If you have not yet created the export, you need to create the export from > the v7 system, using the v7 export executable, with a connect string to > the v8 database. > > > In the version 8 database, run the script > $HOME/rdbms/admin/catexp7.sql > as user sys. (I don't believe this is critical, but it can't hurt.) > > On the v7 database, export from the v8 database using a connect string > > $ exp sys/pwd@db owner=scott file=scott.dmp > > Good luck! > Barb > > > ---------- > From: Nirmal Kumar Muthu Kumaran[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, October 04, 2001 6:40 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Export - Import from Oracle v8 to v731 > > Hi christopher, > > How i can make my orace8 server compatible with v731... is i can set any > init.ora parameter.... > > or something different.... > > Nirma, > > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 8:30 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Export - Import from Oracle v8 to v731 > > Don't know if this would work, but here's a thought. > > Go to the 731 box, set up a connect string to the v8 box. Using the > 731 > exp, export the v8 database (after you set its compatible option to 7 and > bounce it). See if it will import using the 731 imp. > > I don't have any environment to test this in but I think I remember > that > using the 731 exp is the trick. > > > > > > Christopher > > Spence To: Multiple recipients of > list ORACLE-L > <cspence <[EMAIL PROTECTED]> > > @FuelSpot.com cc: > > > Subject: RE: Export - Import > from Oracle v8 > Sent by: root to v731 > > > > > > 10/03/2001 > > 12:25 PM > > Please > > respond to > > ORACLE-L > > > > > > > > > > > > You generally cannot export from a higher leveldatabase to a lower. > Although you can probably change the compatible option to 7.3.4 and do it > that way (from what I hear, never tried it). > > > > "Do not criticize someone until you walked a mile in their shoes, > that way > when you criticize them, you are a mile a way and have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax: (707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > -----Original Message----- > Sent: Wednesday, October 03, 2001 11:25 AM > To: Multiple recipients of list ORACLE-L > > > > Hi gurus, > > i need to transfer db design of a small application from oracle > v8(winnt) > to v731(vms=vax). > > I successfully completed the export process: > > c:\>exp80 parfile=c:\exp_par.dat > > exp_par.dat > ------------------- > userid=msalah/msalah@qtel > file=c:\test.dmp > tables=(ctv_tv_dockets) > grants=y > indexex=y > > then am importing this dump file into oracle v731 which is running > on > vms-vax. > > imp_par.dat > ----------------- > userid="ops$cssdba/cssdba#act@csscli" > file=c:\test.dmp > tables=(*) > fromuser=msalah > touser=ops$cssdba > > c:\>imp71 parfile=c:\imp_par.dat > > here it's giving problem: > > IMP-00003: ORACLE error 12151 encountered > ORA-12154: TNS: could not resolve service name > IMP-00000: Import terminated unsucessfully > > Note that in interactive mode also i tried to import, but it's also > not > working. > > I'm expecting the problem is around > ------------------------------------------------------------- > userid="ops$cssdba/cssdba#act@csscli" > ------------------------------------------------------------ > here the password contains # symbol which refers comment usually. > Before once i handled it successfully, but i forgot that way. > > anyone have any idea... > > rgds, > Nirmal. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
