General MySQL Oracle SQL Server

<< < … 15 16 17 18 19 20 21 22 23 24 25 … > >>   ∑:1360  Sort:Rank

Create a Single Index for Multiple Columns in Oracle
How To Create a Single Index for Multiple Columns in Oracle? If you know a group of multiple columns will be always used together as search criteria, you should create a single index for that group of columns with the "ON table_name(col1, col2, ...)" clause. Here is an example of one index for two c... 2019-04-17, 2591🔥, 0💬

Show All Data Files in the Current Database in Oracle
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; col tablespace_... 2019-04-13, 6677🔥, 0💬

Create a New Data File in Oracle
How To Create a New Oracle Data File in Oracle? There is no dedicated statement to create a data file. Data files are created as part of statements that manages other data structures, like tablespace and database.   ⇒ Create a New Tablespace in Oracle ⇐ Show All Data Files in the Current Database i... 2019-04-13, 3128🔥, 0💬

Drop a Tablespace in Oracle
How To Drop a Tablespace in Oracle? If you have an existing tablespace and you don't want it anymore. You can delete a tablespace by using the DROP TABLESPACE statement as shown in the example below: SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created.... 2019-04-13, 2808🔥, 0💬

Create a New Tablespace in Oracle
How To Create a New Tablespace in Oracle? If you want a new dataspace, you can use the CREATE TABLESPACE ... DATAFILE statement as shown in the following script: SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL&gt; SELECT TABLESPACE_NAME, S... 2019-04-13, 2774🔥, 0💬

Rename a Tablespace in Oracle
How To Rename a Tablespace in Oracle? You can easily rename a tablespace by using the ALTER TABLESPACE ... RENAME TO statement as shown in the example below: SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL&gt; ALTER TABLESPACE my_space REN... 2019-04-13, 2666🔥, 0💬

Error: Cannot Identify/Lock Data File in Oracle
What Happens If You Lost a Data File in Oracle? After you shutting down an Oracle database, you accidently deleted a data file from the operating system. If you try to start the database again you will get error when Oracle tries to open the database after mounting the database. The following tutori... 2019-04-09, 3104🔥, 0💬

Remove Data Files before Opening a Database in Oracle
How Remove Data Files before Opening a Database in Oracle? Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline before opening the database. The tutorial exercise shows y... 2019-04-09, 2834🔥, 0💬

Creating New Database Instance Manually
Where to find answers to frequently asked questions on Creating New Database Instance Manually? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on creating Oracle database instances manually using CREATE DATABASE statement. Items in this FAQ collecti... 2019-04-09, 2819🔥, 0💬

Add Another Datafile to a Tablespace in Oracle
How To Add Another Datafile to a Tablespace in Oracle? If you created a tablespace with a data file a month ago, now 80% of the data file is used, you should add another data file to the tablespace. This can be done by using the ALTER TABLESPACE ... ADD DATAFILE statement. See the following sample s... 2019-04-09, 2627🔥, 0💬

Ways to Create an Oracle Database in Oracle
How To Create an Oracle Database in Oracle? There are two ways to create a new database: Use the Database Configuration Assistant (DBCA) to create a database interactively. Use the CREATE DATABASE statement to create a database manually.   ⇒ Create an Oracle Database Manually in Oracle ⇐ Creating N... 2019-04-09, 2581🔥, 0💬

Connect to Oracle Server as SYSDBA in Oracle
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank password and AS SYSDBA option. Here is a sample sessi... 2019-04-03, 4786🔥, 0💬

Select an Oracle System ID (SID) in Oracle
How To Select an Oracle System ID (SID) in Oracle? This is Step 1. If you are planning to create a new database, you need to select an Oracle System ID (SID). This ID will be used to identify the new Oracle database and its Oracle instance. SID must be unique if you want to run multiple databases on... 2019-04-03, 4086🔥, 0💬

Create an Initialization Parameter File in Oracle
How To Create an Initialization Parameter File in Oracle? This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters. The easiest way to create an initialization parameter file to copy from t... 2019-04-03, 3156🔥, 0💬

Establish Administrator Authentication to the Server in Oracle
How To Establish Administrator Authentication to the Server in Oracle? This is Step 2. There are two ways to establish administrator authentication to a new database. Use a password file. Use operating system (OS) authentication. Using OS authentication is easier on Windows system. If you used your ... 2019-04-03, 2807🔥, 0💬

Create an Oracle Database Manually in Oracle
How To Create an Oracle Database Manually in Oracle? Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement: Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Administrator Authentication Method Step 3: Create t... 2019-04-03, 2714🔥, 0💬

Introduction to Oracle PL/SQL
Where to find answers to frequently asked questions about Oracle PL/SQL in general? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle PL/SQL in general. This FAQ can also be used as learning tutorials on creating procedures, executing proc... 2019-03-27, 2905🔥, 0💬

Running CREATE DATABASE Statement Again in Oracle
How To Run CREATE DATABASE Statement Again in Oracle? After cleaning up the results of a previously failed CREATE DATABASE statement, you can run the CREATE DATABASE statement again as shown below: SQL&gt; @$ORACLE_HOME\config\scripts\c reate_database_fyi.sql;CREATE DATABASE FYI * ERROR at line ... 2019-03-27, 2879🔥, 0💬

Clean Up When CREATE DATABASE Failed in Oracle
How To Do Clean Up If CREATE DATABASE Failed in Oracle? To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Try the CREATE DATABASE statement again, when you h... 2019-03-27, 2833🔥, 0💬

Build Data Dictionary View in Oracle
How To Build Data Dictionary View of an New Database in Oracle? This is Step 9. The Oracle Administrator Guide suggests to run two SQL scripts provided by Oracle as shown bellow: SQL&gt; @/u01/oracle/rdbms/admin/catal og.sqlSQL&gt; @/u01/oracle/rdbms/admin/catpr oc.sql  ⇒ Introduction to Ora... 2019-03-27, 2522🔥, 0💬

Create Additional Tablespaces in Oracle
How To Create Additional Tablespaces for an New Database in Oracle? This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script: SQL&gt; CREATE TABLESPACE users 2 DATAFILE '/oraclexe/oradata/FYI/users01 .dbf'SIZE 10... 2019-03-27, 2501🔥, 0💬

Execution Flow Control Statements in Oracle
What Are the Execution Flow Control Statements in Oracle? PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly executes a block of stateme... 2019-03-27, 3186🔥, 1💬

Create a Simple Stored Procedure in Oracle
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can use the CREATE PROCEDURE or FUNTION statement. The example script below creates a stored program unit: SQL&gt; set serveroutput on; SQL&gt; CREATE PROCEDURE Hello AS 2 BEGIN 3 DBMS_OUTPUT.PUT_... 2019-03-20, 5392🔥, 0💬

What Is a Stored Procedure in Oracle
What Is a Stored Program Unit in Oracle? A stored program unit, or procedure, is a named block of codes which: Has a name. Can take parameters, and can return values. Is stored in the data dictionary. Can be called by many users.   ⇒ Create a Simple Stored Procedure in Oracle ⇐ Run the Anonymous Bl... 2019-03-20, 2857🔥, 0💬

<< < … 15 16 17 18 19 20 21 22 23 24 25 … > >>   ∑:1360  Sort:Rank

General MySQL Oracle SQL Server