No question at this time
DBA Top 10
1 M. Cadot 6600
2 B. Vroman 3400
3 J. Péran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 900
6 P. Wisse 600
7 T. Boles 400
7 D. Walgude 400
7 D. Johnson 400
10 J. Alcroft 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48675
Total active users1328
Act. users last 24h0
Act. users last hour0
Registered user hits last week24
Registered user hits last month452
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, 220 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, 220 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, 215 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, 213 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, 213 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, 212 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