Shulou(Shulou.com)06/01 Report--

Write at the front:

The default tablespace used by Oracle when creating users is User, which is generally not recommended, because the size of the default tablespace is fixed. If all the users we create use the default tablespace, it will lead to insufficient tablespace and make it impossible for all users pointing to the User tablespace to use it normally. It sounds like a terrible thing, so I suggest you use the database in a standardized way. Standardize the creation of users, here the author recommends that you create a separate tablespace object for each user.

How to create a user, the author suggests that it is divided into the following three steps:

1. Create a tablespace

Create tablespace empit logging datafile'd:\ app\ administrator\ oradata\ orcl\ empit.dbf' size 1024m reuse extent management local segment space management auto

Create a tablespace empit and specify a size of 1024m. (the author's Oracle is installed on disk D)

two。 Create a user

Create user empit identified by empi default tablespace empit temporary tablespace temp profile default

Create the user empit/empi and specify the tablespace.

3. Assign permissions

Grant connect,resource,dba to empit

Assign the permissions we may use to the created users (please consult the relevant materials for specific permissions, and the author will not fill them out here).

After creating the database user, we usually import the data into the new database. At this time, we can choose to use the command to achieve this operation. The specific operation is to open the CMD window and enter the following command to execute. Imp username/pwd@IP: Port / instance name file=filepath full=y.

Such as:

Imp empit/empi@127.0.0.1/orcl file = d:\ empit.dmp full=y

As the author's work at the beginning of the mountain, if there is any unclear or incorrect expression, please point out. Thank you. Other knowledge will be updated later.

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.