This content has been marked as final. Show 15 replies
or any way to migrate with best way> will be any impact after migrating.expdp/impdp
will be appreciated fro right answers.
do you think cold backup doesnt work? in this case we can apply archievs
but by expdp/impdp no option right?
Thanks for your response.
1)i did clone database from enterprise edition to standard edition, no invalid objects found ( from production to development)
2) i did restoration using RMAN backupsets from ENterprise edition to standard edition , no invalid objects found (from production to development)
3) i did cold backup from enterprise edition to standard edition , no invalid objects found ( test machine)
i already checked this before, but here mentioned as to use traditional export / import instead of expdp/impdp. ?
The SOLE purpose of backup is to RESTORE exactly what you started with.
The CONTENT of the backed up database was Enterprise Edition.
The CONTENT of the backup files is Enterprise Edition, so what you restored was Enterprise Edition.
I do not care what software (EE or SE) is used during the process.
You start with EE & you end up with EE contents!
You have made a clone of the EE edition and thus made a database using that backup. I am not sure that how are you saying that you have cloned it to a standard edition since nowhere in that process when you would use backup, oracle would ask you about the edition. That's why it was asked to use to export/import since you would have an enteriprise edition whose export you would take and get it imported on a db created in the standard edition.
Yes you are right, i have taken backup from enterprise edition and restored in standard edition,
now the database using standard edition with oracle enterprise edition database. but i didt find any errors/invalid objects.
we need to folllow as per metalink, that is fine...
i have db links with my database,
1) so i need to drop those dblinks before export?
2) need to disable constraints?
or can i go for directly with expdp/impdp
your inputs are valuable SB
Thanks for your valuable response,
really i didt get you, sorry, can you please tell me in brief if you dont mind.
Status Level: Newbie
Registered: Jul 27, 2010
Total Posts: 24
Total Questions: 8 (7 unresolved)
So many questions & so few answers.
Nothingh New here in my post....
The Correct approach is to use the export/import method to carry out the migration. NO other way !!!!!
please can any one provide..
can i go for transportable tablespaces?
can i go for transportable tablespaces?NO!
What is CONTENT of tablespace?
Does tablespace contain EE objects?
What happens when you move tablespace with EE objects?
You can lead some folks to knowledge, but you can't make them think!
some tablespaces contain , tables
some tablespaces contain only indexes.
All what I said that when you took a backup of a db X and made a clone of it using that very same backup another db Y, you have simply cloned the db. There is no where oracle would ask you abotu the edition of the software. That's why you would end up being in EE before and after the cloning process. What you need to do is to take an export of the db made in EE , make another db in SE, import that export dump in it.1 person found this helpful