Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
User and schema creation operations are the same in Oracle. When you create a user, a schema is automatically created for the user. Each …
Read More »
ORACLE
How To Add Datafile To Tablespace On Oracle
As the Oracle database grows, the existing data files in the tablespace will fill up. In such a case, you will need to add …
Read More »How To Connect To RMAN
In this article, I will tell you how to connect to RMAN. We are doing ssh with server as root user. You can use …
Read More »How To Create a .profile File To Connect The Oracle
To connect to Oracle with sqplus you need to load the environment. You need to use the .oraenv or .profile file to load the …
Read More »How To Connect To Oracle With sqlplus
In this article, I will tell you how to connect to the oracle database with sqlplus after connecting to server with ssh. We are …
Read More »
How To Connect To Oracle With Toad
To connect to Oracle with Toad, you need to download and install Toad. TNS Information You must write the tns information of the database you …
Read More »
How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)
We can find oracle service name with two method. TNS information is required to connect to Oracle. In the service_name parameter in the TNS information, …
Read More »
How To Remove Database Target From oem
In this article we will see how to remove a database from oem. You should remove deleted databases from oem. First connect to oem and …
Read More »
How To Create Oracle Profiles
We will create oracle profile and explain with all details. What are Oracle SQL Profiles? Oracle Profiles allow us to manage users according to certain …
Read More »
How To Change User Profile in Oracle
We will change user profile in Oracle in this article. Its very easy and simple step. Profiles allow us to manage users according to certain …
Read More »