Database Administration (MOSC)

MOSC Banner

Is it possible to change characterset of a Custom DB Template using DBCA

edited Sep 15, 2015 10:02AM in Database Administration (MOSC) 5 commentsAnswered

I created a custom Oracle 12c DB with specific values. Original Characterset is UTF8.

I created a template from that DB (structure as well as data).

I then use dbca -silent to create multiple databases but it doesn't change the characterset

dbca -silent -createDatabase -characterSet WE8MSWIN1252 -templateName $ORACLE_HOME/assistants/dbca/templates/oftst01_UTF.dbc -gdbname $sid -sid $sid -sysPassword password -systemPassword password

Is there any way to create a custom template that allows you to change the characterset. I know I can create a (structure only) template but this effectively creates a database from scratch each time taking in excess of 40 minutes each time.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center