Hi im going to take bakup from Oracle 9i & resore in 11g R2, below are the exp command going to execute,what are the other necessary details i need to includeother than below
exp dlsri@sdld full=y file=/install/backup/full.dmp log=/install/backup/full.log
Please assit this
Also if you have Metalink support Check this
Compatibility Matrix for Export And Import Between Different Oracle Versions [Video] [ID 132904.1] And if your issue is resolved you can close this thread as it save time for users looking for open questions
Extremely sorry for late response, when im trying using this in our database according to your tablespace gather sql could not revive proper output
select ‘create tablespace ‘ || df.tablespace_name || chr(10)
|| ‘ datafile ”’ || df.file_name || ”’ size ‘ || df.bytes
|| decode(autoextensible,’N',null, chr(10) || ‘ autoextend on maxsize ‘
|| ‘default storage ( initial ‘ || initial_extent
|| decode (next_extent, null, null, ‘ next ‘ || next_extent )
|| ‘ minextents ‘ || min_extents
|| ‘ maxextents ‘ || decode(max_extents,’2147483645′,’unlimited’,max_extents)
|| ‘) ;’
from dba_data_files df, dba_tablespaces t
Please follow this sql statement & are there any changes to do this,Please if there any changes to do please tell because im in stuck with this.
Please advice need your assistance
Sorry for that script.
It would be better if you just follow the steps i.e--
Look on for Character Set as mentioned in the link.
1)Create dump file backup of Oracle 9i database with the help of Oracle Export Utility.
2)Then you can generate the user creation script and tablespace creation script from the source database.Actually depends on how many users are present in your database.If less you can use dbms_metadata to generate ddl how to get ddl of users and roles?
3)Install The Oracle binaries and Create Oracle database and create users and tablespace from ddl generated from Oracle 9i database.
4)After that try to do import