How to use oracle after installation

After Oracle is installed, you can use the following steps: Create a database instance. Connect to the database. Create a user. Create a table. Insert data. Query data. Export data. Import data.

How to use Oracle after installation

After installing the Oracle database, the next step is to configure it and use it. Here are the steps to use Oracle:

1. Create a database instance

• Open a command prompt or terminal window.
• Navigate to the Oracle installation directory (for example, C:\app\oracle\product\12.2.0\dbhome_1).

• Enter the following command:

  • Windows: dbca
  • Linux/Unix: dbca -silent
• Follow the on-screen instructions to create a new DB instance.

2. Connect to the database

• Open SQL*Plus or other database client tools.

• Enter the following command:

  • Username: system
  • Password:
  • SID (Service Identifier):

3. Create a user

• Enter the following command:

  • CREATE USER IDENTIFIED BY ;
  • GRANT CONNECT, RESOURCE TO ;

4. Create a table

• Enter the following command:

  • CREATE TABLE ( , ...);

    5. Insert data

    • Enter the following command:

      • INSERT INTO
    VALUES (, ...);

    6. Query data

    • Enter the following command:

      • SELECT * FROM
    ;

    7. Export data

    • Enter the following command:

      • EXP @ FILE=;

    8. Import data

    • Enter the following command:

      • IMP @ FILE=;

    hint:

    • Replace , , <sid></sid> , and to suit your situation.
    • For detailed instructions and advanced options, see the Oracle documentation.

The above is the detailed content of How to use oracle after installation. For more information, please follow other related articles on the PHP Chinese website!