The following describes how to import ORACLE data to a local computer from a server. If you are interested in importing ORACLE data, take a look.
Grant all tables under the stat user to the mid user, that is, the mid user can access the tables under the stat user;
Sqlplus stat/stat log on with this user
Select 'Grant select, insert, update, delete on stat. '| table_name |' to mid; 'from user_tables;
Then select all the statements listed to go to The sysdba permission for the operation:
Sqlplus "/as sysdba"
Then execute all the preceding statements;
The stored procedure under the stat user accesses the stored procedure under the mid User:
Access the sysdba permission to perform the following operations:
Grant execute any procedure to mid
Grant execute any procedure to stat
The stored procedure under the stat user accesses the types temporary table under the mid user.
Grant the stat User execute any type to stat.
The second method is to import the ORACLE data on the server to the local machine. This method does not include the tablespace and temporary tablespace created on the server during export.
You only need to use the default tablespace.
Run the following command in CMD mode:
Exp username/password @ Server Database ID file = c: \ file name. dmp
For example:
Exp djyy/djyy @ zhwx file = c: \ djyy20090921.dmp
Exp wxzd/wxzd @ zhwx file = c: \ wxzd20090921.dmp
Import to the user of the Local Machine. Create a user, log on to PLSQLDEVELOPER with the new user name, and select the Imports Tables option under the Tools menu.
Select the Oracle Import label, and select the imp.exe file in the db_1 \ bindirectory under the Oracle installation directory in Import Executable (usually
If this item does not exist, you can select the imp.exe file to execute the import ).
In Import file, select the exported dmp suffix file name, and then execute Import to Import
The statement for creating a tablespace is as follows:
CREATE TABLESPACE ZHWXSYS
DATAFILE 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ ZHWXSYS. dbf'size 500 M
Uniform size 128 k;
The statement for creating a temporary tablespace is as follows:
CREATE TEMPORARY TABLESPACE ZHWXTMP
TEMPFILE 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ ZHWXTMP. dbf' SIZE 50 M
Differences between Oracle users and Models
View oracle user permissions
How to store images in oracle
Implementation of oracle tree Query
Implementation of oracle query current time