I am just looking for best and fast method to clone the database from NT to UNIX . I can't use backup control file and copy data files , since it is different OS . I can't use transportable tablespaces for the same reason . I got around 500 tables in 5 schemas . Even export/import doesn't work ,since i have to copy export file to new OS ..looking for solution ..
Since my database is big . Easy way to import is , copy the file to local machine , where DB is running and start importing . Other wise I have to connect to Unix machine from nt client and have to perform import . MY DB size is 200 GB .
It would be a lot easier to stay within the same platform i.e.
either go unix to unix or nt to nt. I would only go from nt to unix if it was a once shot deal in your case. Did you mean that your export is 200GB? You could do the export, zip the file, ftp it to unix, do a gunzip, and then import. This will shrink the size of the file that you are sending via ftp.
You should do 5 exports, one for each schema. This should make each export file smaller. I think that there is a way to make exports span over multiple files, but I haven't done that myself. and make sure that you take the database out of archive log during the import, have plenty of rollback, and a large temp tablespace.
Originally posted by gandolf989 You should do 5 exports, one for each schema. This should make each export file smaller.
I don't see any point in doing so. Why not simply perform full database export? Mind you, there are things that are exported in FULL mode but not in USER mode - what about those?. Cloning a database means creating an exact replica of the database, and the only way to do this (while switching the platform) is by doing FULL exp/imp.
Regarding the size of the dump file: as gandolf989 allready pointed out, you can make export dumping data into many smaller files.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?