No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48667 | Total active users | 1333 | Act. users last 24h | 2 | Act. users last hour | 1 | Registered user hits last week | 22 | Registered user hits last month | 182 |
|
Go up
Drop Sample Schemas from Oracle Database
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 |
Subject: |
Drop Sample Schemas from Oracle Database |
Author: |
saumya das, India |
Date: |
Nov 24, 2021, 20:24, 181 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, 181 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, 176 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, 174 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, 174 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, 174 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
|