Export from 8.1.7 Import into 10g. ROWs only ie without objects,index,grants etc
Hi,
I am working on a Oracle Forms
conversion
project.
The existing environment is Solaris 5.6, DB 8.1.7, OAS 4.0.8 and Forms 5.0
The new environment is Solaris 10, DB 10g, IAS 10g, Forms 10g.
I created scripts to create schemas, stored procedures, triggers etc in the new environment. Converted the Forms 5.0 to Forms10g.
In 10g , I had to change some of the stored procedures because of minor enhancements and the conversion itself.
Then I tried to export the data from old database . I used script file and its contents are :
$ cat exp_small_tables
userid=system/<pwd>
file=small_tables.dmp
log=small_tables.log
The existing environment is Solaris 5.6, DB 8.1.7, OAS 4.0.8 and Forms 5.0
The new environment is Solaris 10, DB 10g, IAS 10g, Forms 10g.
I created scripts to create schemas, stored procedures, triggers etc in the new environment. Converted the Forms 5.0 to Forms10g.
In 10g , I had to change some of the stored procedures because of minor enhancements and the conversion itself.
Then I tried to export the data from old database . I used script file and its contents are :
$ cat exp_small_tables
userid=system/<pwd>
file=small_tables.dmp
log=small_tables.log
0