Oracle local database connection

Oracle local database connection
* ****************** Create a tablespace and User Name

/* Step 2: create a data table space */
Create tablespace flx
Logging
Datafile 'e: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ flx. dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;

/* Step 2: create a user and specify the tablespace */
Create user flx identified by flx
Default tablespace flx

/* Step 4: grant permissions to users */

Grant connect, resource, dba to flx;

* ************** Import the Data Structure

Commands for importing dmp files from oracle
1. First enter the cmd command window
2. Run the command: imp userid = user name/password @ database name file = d: \ daochu. dmp full = y ignore = y

File: the full path of the dmp file to be imported.
Full = y indicates whether all data is imported. This option can be used only when the current user is a dba.
If an existing table exists, an error will be reported during the import. If this table is not imported, add ignore = y.

* ************* Stop the local listening service after it is started

E: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ listener. ora, change the content in this file to HOST = your computer name, and restart it.

* *********** Use a tool to import (export) the selected execution File Location

E: \ oracle \ product \ 10.2.0 \ db_1 \ bin \ imp.exe(exp.exe)