ORACLEÊý¾Ý¿âµ¼³ö - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚÊý¾Ý¿â½¨Á¢ÁËÒ»¸öÓû§£¬¸ÃÓû§ÏÂÓÐһЩ¶ÔÏó£¬ÈçºÎµ¼³öÄØ£¿ÓÃʲôÓû§Ö´Ðе¼³ö²Ù×÷£¿

---

sqlplus /nolog 
conn / as sysdba 
exp Test1/Test1passwd owner=Test1 file=D:\files\Test1.dmp 

ÊÇ·ñ·ûºÏÄãµÄÒªÇó?

---

ÒýÓÃ

ÔÚÊý¾Ý¿â½¨Á¢ÁËÒ»¸öÓû§£¬¸ÃÓû§ÏÂÓÐһЩ¶ÔÏó£¬ÈçºÎµ¼³öÄØ£¿ÓÃʲôÓû§Ö´Ðе¼³ö²Ù×÷£¿

¿ÉÒÔʹÓÃplsql developer½øÐÐÊý¾Ýµ¼³ö ºÜ·½±ãµÄ

---

SQL code:

--ÏÂÃæÓÃʵÑé˵Ã÷Á½¸öschemasÖ®¼äµÄµ¼³öµ¼È룬ϣÍûÄÜ°ïµ½Äã¡£

[oracle@rles tools]$ pwd
/tools
[oracle@rles tools]$ mkdir expdir
[oracle@rles tools]$ pwd
/tools
[oracle@rles tools]$ exit
exit

SQL> conn system/oracle
Connected.
SQL>
SQL>
SQL> show user
USER is "SYSTEM"
SQL>
SQL> create directory expdir as '/tools/expdir';

Directory created.

SQL> conn scott/tiger
Connected.
SQL>
SQL> select count(*) from user_objects;

COUNT(*)
----------
8

SQL> conn / as sysdba
Connected.
SQL>
SQL> create user expdp identified by expdp default tablespace test temporary tablespace temp quota unlimited on test;

User created.

SQL> grant connect,resource,create session to expdp;

Grant succeeded.

SQL> conn expdp/expdp
Connected.
SQL>
SQL> select count(*) from user_objects;

COUNT(*)
----------
0

SQL>