No question at this time
DBA Top 10
1 M. Cadot 5800
2 B. Vroman 3800
3 J. Péran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 800
6 D. Johnson 700
7 T. Boles 600
8 D. Walgude 400
9 J. Alcroft 200
9 S. Spb 200
9 P. Wisse 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48667
Total active users1333
Act. users last 24h2
Act. users last hour1
Registered user hits last week22
Registered user hits last month182
Go up

Drop Sample Schemas from Oracle Database
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...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Joël Péran Nov 25, 2021, 07:43
Hi, schemas that you listed are NOT sample sche...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts 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, 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:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
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:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
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