Oracle SQL Developer无Database文件夹，无法按Microsoft SQL Server教程新建数据库求助

Got it, let's clear up the confusion here—Microsoft SQL Server and Oracle have fundamentally different database architectures, which is why that "database" folder you're looking for doesn't exist in Oracle SQL Developer. Here's what you need to know:

Key Concept Difference #

• In SQL Server, you can create multiple independent databases as isolated units for storing data objects (tables, views, etc.). This is exactly what your tutorial is doing with the "new database" option.
• In Oracle, a single instance typically maps to one database. Instead of creating new databases for isolation, developers use Schemas (Users) or Tablespaces to separate their work. For most everyday development tasks, creating a Schema (linked to a user account) is the direct equivalent of SQL Server's "new database".

Step-by-Step to Create Your Isolated Environment (Equivalent to SQL Server's Database) #

If you just need a dedicated space to build your own tables and objects (like the tutorial's new database), follow these steps in Oracle SQL Developer:

1. First, confirm you have the necessary permissions (if not, ask your DBA to grant you CREATE USER and GRANT privileges).
2. After connecting to your Oracle instance, locate the Other Users folder in the left navigation pane.
3. Right-click on Other Users → select New User.
4. Fill in the required details:
   • Enter a username (this will be your Schema name) and a secure password.
   • Switch to the Tablespaces tab: Assign a default tablespace (use USERS if you don't need custom storage, or create a new tablespace first for dedicated space).
   • Switch to the System Privileges tab: Grant essential privileges like CREATE SESSION (to log in), CREATE TABLE, CREATE VIEW, and any others you need for your tutorial work.
5. Click Apply to create the user/schema. You can now expand this user in the navigation pane to create tables, views, etc.—just like you would in a SQL Server database.

What If You Really Need to Create a Full Oracle Database? #

This is a DBA-level task, not something most developers do day-to-day. It requires server-side tools like the Database Configuration Assistant (DBCA) or running the CREATE DATABASE command via SQL*Plus. This is far more involved than SQL Server's "new database" wizard, and usually only done when setting up a new Oracle instance from scratch.

内容的提问来源于stack exchange，提问作者W.M