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

Editor to share with you navicat to create oracle table method, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

1. Oracle installation

Https://blog.csdn.net/libingbojava/article/details/82025702

Use Navicat to connect to the Oracle database after installation.

The username is temporarily logged in using system, and the password is the password set during installation. XE is the folder where CONTROL.DBF is stored.

2. Create Oracle data sheet

Create a table:

1. Create a data tablespace

2. Create a user (specify the currently created tablespace by default)

Delete the table:

1. Delete a user

2. Delete the data tablespace

The order cannot be reversed, if the data table is deleted first, the user's default tablespace will not be found and the database will not be opened.

Delete the tablespaces on disk manually after the deletion is complete.

When creating a tablespace, the name must be capitalized, or there will be an error after creating the discovery path.

When you create a user, the default tablespace is the one you just created.

Assign permissions

Minimum login privileges

In "member belongs" we selected the "DBA" permission. In fact, for ordinary users, we only need to give connect, resource, create view these permissions. But here we chose "DBA" for demonstration convenience.

Reference https://www.cnblogs.com/franson-2016/p/5925593.html

III. Data transmission

Re-log in to the created user for data transfer, and the user has the right to operate the table.

The above is all the contents of the article "navicat's method of creating oracle tables". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.