No question at this time
DBA Top 10
1 M. Cadot 6700
2 B. Vroman 3900
3 A. Kavsek 2700
4 J. Péran 1700
5 T. Boles 600
5 D. Johnson 600
7 T. P 500
8 P. Wisse 400
9 S. Spb 300
10 V. Gupta 200
10 M. Jain 200
10 K. Pingeli 200
10 R. Pastre 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48649
Total active users1380
Act. users last 24h1
Act. users last hour0
Registered user hits last week81
Registered user hits last month279
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, 12 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, 12 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, 7 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, 5 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, 5 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, 5 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