• Oracle

    Oracle database Migration and upgrade-25

    Migration Migration is a major release change. Ex: 9i to 10g or 11g (OR) 10g to 11g. Migration will be going from lower to higher version. The windows to Linux will be cross platform migration.   Migrate from 9i Windows to Linux Pre-requesting Note down the following. Sql> select username,default_tablespace from dba_users; Sql> select * from dba_ts_quotas; Sql> select tablespace_name sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;   Step 1: Export Schema D:\> exp system/manager file D:\muthu.dump owner =Muthu log=D:\muthu.log Step 2: Move the dump file to Linux D:\> ftp 192.168.9.1 Login: ftp> cd /opt ftp> lcd D:\ ftp> bin ftp> put Muthu.dump ftp> bye   Step 3: Create a same…