how i get all table with date form old database folderor table spase to new
mfa786Aug 31 2006 — edited Aug 31 2006Sir I use form6i with 9i engine but other my system use 8 with developer 6 not 6i
I need connect with oracle 8 for import the data but system not give me accesses my other friend give me idea you install developer 6 then you access easily I tried but system that installation create new oracle_home after that I open my 9i database form enterprise manager then system give me error close connection when I check sqlplus then system give me this error
D:\>sqlplus /as sysdba
Error 6 initializing SQL*Plusc
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
sir I try these command
c:\ set ORACLE_HOME=c:\oracle9i
c:\ set ORACLE_SID=aamir
c:\ sqlplus / as sysdba
after this command system give me this error
incorrect environment variable plus_dflt program execution error
sir my oracle9i database folder is c:\oracle9i and my developer 6i form is c:\oraform
after this sir i format my system and istall new oracle with same name aamir
but sir my all data in old aamir engine and i save old oracle data folder aamir with all files
sir how i get all table with date form old aamir folder in new database aamir
sir please give me idea how I get old date form olde aamir folder
thanks
aamir