{"id":1360,"date":"2007-11-20T12:00:00","date_gmt":"2007-11-20T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1360"},"modified":"2007-11-20T12:00:00","modified_gmt":"2007-11-20T12:00:00","slug":"enterprise-to-standard","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/11\/20\/enterprise-to-standard\/","title":{"rendered":"Enterprise to Standard?"},"content":{"rendered":"

OK, it’s a little cheeky to use the blog for this when there are so many forums I could post this on and friends I could ask. What can I say? I have a lot of respect for the people who congregate around here, so ….<\/p>\n

Does anyone have much experience of migrating their databases from Enterprise Edition to one of the cheaper editions, such as Standard? Did you find it an easy experience or not? Are there any unexpected issues you encountered?<\/p>\n

There’s no substitute for prior experience here, so feel free to share yours and I’ll be grateful<\/p>\n","protected":false},"excerpt":{"rendered":"

OK, it’s a little cheeky to use the blog for this when there are so many forums I could post this on and friends I could ask. What can I say? I have a lot of respect for the people who congregate around here, so …. Does anyone have much experience of migrating their databases… Continue reading Enterprise to Standard?<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1360","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1289,"url":"http:\/\/orcldoug.com\/blog\/2007\/07\/04\/awr-licensing\/","url_meta":{"origin":1360,"position":0},"title":"AWR Licensing","date":"July 4, 2007","format":false,"excerpt":"I thought I'd wait for a few days to see how the open letter to Larry Ellison on the subject of AWR licencing panned out.I love AWR, ASH and I even have an increasing, slightly grudging and cynical respect for ADDM. In fact, I'm in the course of putting together\u2026","rel":"","context":"With 15 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1264,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/06\/re-linking-oracle\/","url_meta":{"origin":1360,"position":1},"title":"Re-linking oracle","date":"May 6, 2007","format":false,"excerpt":"Hooray! Something vaguely technical - at last.My new client is hot on software licence compliance and what seemed a minor issue to me reared it's slightly ugly head this week. When connecting to our 10.2.0.2 database instances using sqlplus, the version banner displays options that we aren't using, for example\u2026","rel":"","context":"With 21 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":895,"url":"http:\/\/orcldoug.com\/blog\/2005\/12\/07\/oracle-enterprise-manager-10gr2\/","url_meta":{"origin":1360,"position":2},"title":"Oracle Enterprise Manager 10gR2","date":"December 7, 2005","format":false,"excerpt":"First of all, let me be clear that I'm not a fan of GUI tools. That's not based on a misguided macho opinion that somehow you need to be able to struggle with a command line interface to prove that you're a good DBA but because :- I'm a contractor\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1688,"url":"http:\/\/orcldoug.com\/blog\/2014\/08\/14\/openworld-schedule-builder-is-live\/","url_meta":{"origin":1360,"position":3},"title":"Openworld Schedule Builder is live","date":"August 14, 2014","format":false,"excerpt":"I received an email that the online Schedule Builder is live. I might regret saying this but, based on an initial glance, it's an improvement on previous efforts. (Which wouldn't be difficult!) For anyone who is interested in seeing some of the cool OEM12c Performance Page stuff, my session is\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":884,"url":"http:\/\/orcldoug.com\/blog\/2006\/01\/12\/something-else-i-didnt-know\/","url_meta":{"origin":1360,"position":4},"title":"Something Else I Didn’t Know","date":"January 12, 2006","format":false,"excerpt":"This one is courtesy of Andrew Campbell at Sun Microsystems. He noticed in an Oracle Magazine article that you can use a URL as a script name in sqlplus.SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL\/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for 32-bit Windows:\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":913,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/04\/resetting-vfilestat-timings\/","url_meta":{"origin":1360,"position":5},"title":"Resetting v$filestat timings","date":"November 4, 2005","format":false,"excerpt":"As I mentioned in a previous blog, I learnt something new from Anjo Kolk's SAN presentation at the Oak Table day at the UKOUG conference. Instead of looking at the maximum read time for a file since the instance started or the average in a statspack report, you can reset\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1360"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1360\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1360"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}