if i will rate my oracle expertise i would give it 3/10. i just started learning oracle, solaris and linux 2months ago and was given this task to migrate. yes our oracle version is quite old and might not be supported anymore. Both platforms has the same Oracle Versions, only difference is patch version of linux is 10.2.1 compared to my source database solaris sparc 10.2.4.
our database is about 20GB in size. tablespace is about 16 including the default that came in during the installation of Oracle. 1 tablespace has 25 datafiles which i think would be the main tablespace that the system is using and other tablespaces averages 2-3 datafiles each.
i have tried the datapump method first. upon importing, errors are being encountered that users and roles does not exist. i think what the datapump import is doing is importing the data first before the users that is why it is looking for the users/schema's which it belongs.
i have decided to use the transportable tablespace method and was able to convert and transport tablespaces that are self contained or do not have objects that relies on other tablespaces. which will lead me to my main question, how to i proceed in migrating the tablespaces that have objects dependencies to other tablespaces? or if the datapump method is easier, i can go back to that method.
thank you in advance and we appreciate all the help we can get with this activity.