Go up

Next thread:	PL/SQL lock timer event not result of dbms_lock.sleep
Prev thread:	Restoring incremental backup

Message	Score	Author	Date
Hi , Can I drop the sample schemas like MDDATA,......		saumya das	Nov 24, 2021, 20:24
Hello A suggestion ? Ask My Oracle Support abou......		Joël Péran	Nov 25, 2021, 07:43
Hi, schemas that you listed are NOT sample sche......		Ales Kavsek	Nov 30, 2021, 12:31
Hi Ales , Thanks for your suggestion , I checke......		saumya das	Dec 01, 2021, 19:50
Hi Joel , Thanks for your suggestion. Thanks......		saumya das	Dec 01, 2021, 19:51
Hi, you'll find all the necessary links to offi......		Ales Kavsek	Dec 02, 2021, 12:45

Follow up by mail

Click here

---

Subject:	Drop Sample Schemas from Oracle Database
Author:	saumya das, India
Date:	Nov 24, 2021, 20:24, 368 days ago
Os info:	AIX 7
Oracle info:	oracle 12c RAC
Message:	Hi , Can I drop the sample schemas like MDDATA,OLAPSYS,ORACLE_OCM,SI_INFORMTN_SCHEMA,XDB,OWBSYS, CTXSYS, APEX_040200 in Oracle database. Does this have any impact. is there any specific procedure to delete these schemas. Any suggestions is highly appreciable. Regards Saumya
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: Drop Sample Schemas from Oracle Database
Author:	Joël Péran, France
Date:	Nov 25, 2021, 07:43, 368 days ago
Score:
Message:	Hello A suggestion ? Ask My Oracle Support about that ? I don't think you can safely remove some of these components. You have to uninstall them (I mean, components). All you need to know is available at the support. The only schema you can safely remove is SCOTT ie ... Regards, Joel
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: Drop Sample Schemas from Oracle Database
Author:	Ales Kavsek, Slovenia
Date:	Nov 30, 2021, 12:31, 363 days ago
Score:
Message:	Hi, schemas that you listed are NOT sample schemas, they're default schemas that belong to various options. I would strongly suggest that you leave them as they're, because some dependencies exists between them that can get your life miserable if you arbitrary remove them. I'm sure you don't even know for sure if any of your applications depends on them. Read this: https://mikedietrichde.com/2017/07/26/remove-clean-components-oracle-11-2-12-2/ Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: Drop Sample Schemas from Oracle Database
Author:	saumya das, India
Date:	Dec 01, 2021, 19:50, 361 days ago
Message:	Hi Ales , Thanks for your suggestion , I checked the link. Please share me if you have any links from Oracle corporation. regarding this. Thanks Saumya
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: Drop Sample Schemas from Oracle Database
Author:	saumya das, India
Date:	Dec 01, 2021, 19:51, 361 days ago
Message:	Hi Joel , Thanks for your suggestion. Thanks Saumya
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: Drop Sample Schemas from Oracle Database
Author:	Ales Kavsek, Slovenia
Date:	Dec 02, 2021, 12:45, 361 days ago
Message:	Hi, you'll find all the necessary links to official Oracle MOS notes in Mike article that I posted above (just follow the links associated with particular option). You can easily spend a full week reading all linked documents. Anyway, Mike works for Oracle and you won't find any better source of information on this particular topic, trust me;-). Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here