Create a clone from a .bck file (9i to 10g)
673562Oct 23 2009 — edited Oct 21 2010Hello.. Please accept my apologies as I am a beginner with Oracle Database. Here is the problem:
1) I have a backup file of the whole db (over 20 GBs) which is in Oracle 9i. The backup was taken using EXPORT:V09.02.00 utility through "conventional path" (sorry about my weird translation). The backup file has .bck extension.
2)I have installed Oracle 10g on ny personal computer (win xp pro sp2) (the host is my own computer)
3)I want to create an identical database of 9i to 10g.
So here are the questions:
a) Should I create an empty database in 10g using DBCA first?
b) What tool should I use to do this?
c) The database is organised in tablespaces. Do I need to define these tablespaces to the destination db before moving?
I tried to use "Import from Export Files" from the maintainance tab in EM but I get several errors in the log file and finally the job is failing.
Some error codes are:
IMP-00017: the following failed ORACLE 1119:
"CREATE TABLESPACE "PPP1" BLOCKSIZE 8192 DATAFILE 'R:\ORACLE\ORADATA\dbstore\PPP1.DBF' SIZE 10000M REUSE AUTOEXTEND ON NEXT 134217728 MAXSIZE "
"10000M, 'R:\ORACLE\ORADATA\dbstore\PPP2.DBF' SIZE 8640M REUSE AUTOEXTE"
"ND ON NEXT 134217728 MAXSIZE 10000M EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
" ONLINE PERMANENT NOLOGGING SEGMENT SPACE MANAGEMENT AUTO"
There are several other errors following this but I think this is the most crucial because I think the main error is because of tablespaces.
Please accept my apologies for my dump question. I don't want full answers, just a tip where to look to. I really appreciate it!
Edited by: user10675401 on 23 Οκτ 2009 10:32 πμ
Edited by: user10675401 on 23 Οκτ 2009 10:33 πμ