create database character set AL32UTF8 national charset UTF8

Hello,

I search a script to create database character set AL32UTF8 national charset UTF8.

Thanks

Regards

Bibi
bibi92Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
The easiest way to get a create database script that you want is to run the  Database Configuration Assistant (DBCA) tool, select all the options you want including the correct character set and at the very end you have the option to save the statements as a script.

https://docs.oracle.com/database/122/ADMIN/creating-and-configuring-an-oracle-database.htm#ADMIN-GUID-99A93810-62B1-4707-9995-89B3D0B5FB56

If you want any old script, google around for samples and change the characterset in whatever script you find.
0
bibi92Author Commented:
Ok I know DBCA but I search a script thanks
0
slightwv (䄆 Netminder) Commented:
I do not understand what you are asking.  If you are searching for samples, just google:  oracle create database sample scripts
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

bibi92Author Commented:
I search to know if it's possible to create database character set AL32UTF8 national charset UTF8 so having sample script thanks
0
slightwv (䄆 Netminder) Commented:
I'm sorry but I am not understanding the actual question.

Yes, you can create a database in the AL32UTF8  characterset:
https://docs.oracle.com/database/122/NLSPG/glossary.htm#NLSPG608

If you want a sample script that actually creates one, again, google around for sample scripts and replace the characterset with AL32UTF8.

There is an example in the online docs that creates a database with AL32UTF8
Examples

Creating a Database: Example

The following statement creates a database and fully specifies each argument:

https://docs.oracle.com/database/122/SQLRF/CREATE-DATABASE.htm#SQLRF01204

CREATE DATABASE sample
   CONTROLFILE REUSE 
   LOGFILE
      GROUP 1 ('diskx:log1.log', 'disky:log1.log') SIZE 50K, 
      GROUP 2 ('diskx:log2.log', 'disky:log2.log') SIZE 50K 
   MAXLOGFILES 5 
   MAXLOGHISTORY 100 
   MAXDATAFILES 10 
   MAXINSTANCES 2 
   ARCHIVELOG 
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE  
      'disk1:df1.dbf' AUTOEXTEND ON,
      'disk2:df2.dbf' AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE temp_ts
   UNDO TABLESPACE undo_ts 
   SET TIME_ZONE = '+02:00';

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bibi92Author Commented:
thanks regards
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.