Oracle creates a table for the user to import Scott to solve the problem that the table or view does not exist when the new user queries the Scott table.

Create a user in Oracle and import all the tablespaces of Scott users to it

1. Back up the tablespace of Scott/tiger users Go to the console and enter an empty directory. Run the command: EXP An expdat. DMP is generated later. 2. Enter the DBA account Conn sys/sys as sysdba; Create user FPC identified by FPC default tablespace users quota 10 m on users; Grant create session, create table, create view to FPC; 3. Import the tablespace backed up before Go to the directory where the expdat. dmp file was generated before, execute imp, and log on to the new user (FPC/FPC.

Then you can use the newly created user to directly query Scott's EMP, DEPT, and other tables. Otherwise, you must specify Scott's EMP table, if the FCP user needs to use select * from Scott to query EMP. EMP, but now you can directly use select * from emp to query.