Make Custom User Authorization Schemes. Oracle Apex. Part-1

Solve Various Problems Of Oracle Database 19c

 

Solve Various Problems Of Oracle Database 19c

Ora-65096: Invalid Common User Or Role Name

Reason: In Addition To The General Rules For Usernames And Role Names, Common Usernames And Role Names Must Begin With C ## Or C ## And Consist Of Only ASCII Characters. Action: Specify A Valid General Username Or Role Name. The Solution To Ora-06596 Is To Set A Hidden Parameter "_oracle_script". When You Set The Undocumented (Hidden) Parameter "_oracle_script" = True You Can Create A Fred User Without C ## In From The User Id. However, This User Will Not Use A Pluggable / Container Database:

conn sqlplus / as sysdba

alter session set "_ORACLE_SCRIPT"=true;

CREATE USER test IDENTIFIED BY test123
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;

Oracle Support

Always Consult Oracle Support Before Using Any Hidden Oracle Parameters Oracle Makes A Difference In The Multitenant Database For Local Vs. “Normal” User Ids: General User: General User I'd Must Be Generated At CDB Level And Start With A C ## Or C ## Prefix. Local Users: Local Users Can Only Be Created At The PDB Level; You Must Also Use The Container Clause Set To Current To Create A User.

How do I solve all the problems of Oracle database tablespace?

Then I had problems with tablespace and quotas. Log in 

SQLPLUS sys/@localhost/MYDATABASE as sysdba

You can list with all tablespaces 

SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;

You Can Create A New Tablespace With 

CREATE TABLESPACE TABLESPACENAME
    DATAFILE 'tablespace_datafile.dat'
                 SIZE 10 M
                 REUSE
                 AUTOEXTEND ON NEXT 10 M MAXSIZE 200 M;

You Can Throw Away Your Broken Table space 

DROP TABLESPACE TABLESPACENAME INCLUDING CONTENTS AND DATAFILES;

How Can I Resize A Tablespace Oracle Database?

Bigfile tablespaces make datafiles transparent for users. Therefore, you can perform operations directly in tablespace instead of managing each of the underlying datafiles. Bigfile tablespaces simplify datafile management by eliminating the need to add new datafiles or deal with multiple files. It is a good idea to avoid using small file tablespace for your RDS for Oracle instances.

Reduce the size of the tablespace. 

ALTER TABLESPACE example-tablespace RESIZE 40G;

View current default temporary tablespace: 

SELECT PROPERTY_VALUE
  FROM DATABASE_PROPERTIES
 WHERE PROPERTY_NAME = 'DEFAULT_TEMP_TABLESPACE';

Create a new temporary table space: 

CREATE TEMPORARY TABLESPACE example-tablespace TEMPFILE SIZE 100M;

Set the new temporary tablespace as the default temporary tablespace: 

EXEC RDSADMIN.RDSADMIN_UTIL.ALTER_DEFAULT_TEMP_TABLESPACE(TABLESPACE_NAME => 'example-tablespace');

View the current default temporary tablespace for the user: 

SELECT USERNAME, TEMPORARY_TABLESPACE
  FROM DBA_USERS
 WHERE USERNAME = 'example_username';

Change the default temporary tablespace for the user: 

ALTER USER example_username 
    TEMPORARY TABLESPACE example-tablespace;

Identify the undone tablespace currently in use: 

SHOW PARAMETER UNDO_TABLESPACE;

Reduce tablespace undo: 

ALTER TABLESPACE example-tablespace RESIZE 500M;

Undo old table space: 

DROP TABLESPACE example-tablespace INCLUDING CONTENTS AND DATAFILES;

Resize TABLESPACE. 

ALTER DATABASE 
  DATAFILE 'D:\DB_19C\ORADATA\ORCL\ORCLPDB\APEX_1600459807766781.DBF'
 RESIZE 1G;

 

🔗 Demo Application-
            URL- Demo Application
            Username - demo, Pass- demo
 

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................

>