Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people have no idea about how to realize local database connection in Oracle. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

One: create database tablespaces and user names

Createtablespaceflx

Logging

Datafile'E:\ oracle\ product\ 10.2.0\ oradata\ orcl\ flx.dbf'

Size50m

Autoextendon

Next50mmaxsize20480m

Extentmanagementlocal

Two: create a user and specify a tablespace

Createuserflxidentifiedbyflx

Defaulttablespaceflx

Three: Grant user rights

Grantconnect,resource,dbatoflx

Four: import data structure

Oracle Import dmp File command

1. First go to the cmd command window

two。 Execute the command: impuserid= username / password @ database name file=d:\ daochu.dmpfull=yignore=y

File: is the full path of the dmp file you want to import.

Whether full=y imports all or not this option is available only if the current user is dba.

An error will be reported when importing an existing table. Do not import the table and add ignore=y after it.

Five: stop after the local monitoring service starts

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

Six: import (export) the location of the execution file selected by the tool

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

After reading the above, have you mastered how to connect to the local database in Oracle? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.