[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sun Jun 24 01:13:45 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user;\
USER is "SYS"
SP2-0158: unknown SHOW option ";\"
SQL> show user;
USER is "SYS"
SQL> create table tt1 as select username,user_id from dba_users;
Table created.
SQL> select * from tt1;
USERNAME USER_ID
------------------------------ ----------
OLAPSYS 60
SI_INFORMTN_SCHEMA 56
MGMT_VIEW 73
OWBSYS 78
ORDPLUGINS 55
SPATIAL_WFS_ADMIN_USR 66
SPATIAL_CSW_ADMIN_USR 69
XDB 45
SYSMAN 71
APEX_PUBLIC_USER 75
DIP 14
USERNAME USER_ID
------------------------------ ----------
OUTLN 9
ANONYMOUS 46
CTXSYS 43
ORDDATA 54
MDDATA 64
OWBSYS_AUDIT 82
APEX_030200 77
XS$NULL 2147483638
APPQOSSYS 31
ORACLE_OCM 21
WMSYS 32
USERNAME USER_ID
------------------------------ ----------
DBSNMP 30
EXFSYS 42
ORDSYS 53
MDSYS 57
FLOWS_FILES 74
SYSTEM 5
SYS 0
JACK 85
MARK 86
USER1 84
SCOTT 83
33 rows selected.
SQL> create table ett1
2 organization external(
3 type oracle_datapump
4 default directory dmpdir
5 location ('tt123.dmp'))
6 as select * from tt1;
Table created.
SQL> create table ett2(username varchar2(40),user_id number)
2 organization external (
3 type oracle_datapump
4 default directory dmpdir
5 location ('tt123.dmp'));
Table created.
SQL> select * from ett1;
USERNAME USER_ID
------------------------------ ----------
OLAPSYS 60
SI_INFORMTN_SCHEMA 56
MGMT_VIEW 73
OWBSYS 78
ORDPLUGINS 55
SPATIAL_WFS_ADMIN_USR 66
SPATIAL_CSW_ADMIN_USR 69
XDB 45
SYSMAN 71
APEX_PUBLIC_USER 75
DIP 14
USERNAME USER_ID
------------------------------ ----------
OUTLN 9
ANONYMOUS 46
CTXSYS 43
ORDDATA 54
MDDATA 64
OWBSYS_AUDIT 82
APEX_030200 77
XS$NULL 2147483638
APPQOSSYS 31
ORACLE_OCM 21
WMSYS 32
USERNAME USER_ID
------------------------------ ----------
DBSNMP 30
EXFSYS 42
ORDSYS 53
MDSYS 57
FLOWS_FILES 74
SYSTEM 5
SYS 0
JACK 85
MARK 86
USER1 84
SCOTT 83
33 rows selected.
SQL> select * from ett2;
USERNAME USER_ID
---------------------------------------- ----------
OLAPSYS 60
SI_INFORMTN_SCHEMA 56
MGMT_VIEW 73
OWBSYS 78
ORDPLUGINS 55
SPATIAL_WFS_ADMIN_USR 66
SPATIAL_CSW_ADMIN_USR 69
XDB 45
SYSMAN 71
APEX_PUBLIC_USER 75
DIP 14
USERNAME USER_ID
---------------------------------------- ----------
OUTLN 9
ANONYMOUS 46
CTXSYS 43
ORDDATA 54
MDDATA 64
OWBSYS_AUDIT 82
APEX_030200 77
XS$NULL 2147483638
APPQOSSYS 31
ORACLE_OCM 21
WMSYS 32
USERNAME USER_ID
---------------------------------------- ----------
DBSNMP 30
EXFSYS 42
ORDSYS 53
MDSYS 57
FLOWS_FILES 74
SYSTEM 5
SYS 0
JACK 85
MARK 86
USER1 84
SCOTT 83
33 rows selected.
SQL> select * from tt1;
USERNAME USER_ID
------------------------------ ----------
OLAPSYS 60
SI_INFORMTN_SCHEMA 56
MGMT_VIEW 73
OWBSYS 78
ORDPLUGINS 55
SPATIAL_WFS_ADMIN_USR 66
SPATIAL_CSW_ADMIN_USR 69
XDB 45
SYSMAN 71
APEX_PUBLIC_USER 75
DIP 14
USERNAME USER_ID
------------------------------ ----------
OUTLN 9
ANONYMOUS 46
CTXSYS 43
ORDDATA 54
MDDATA 64
OWBSYS_AUDIT 82
APEX_030200 77
XS$NULL 2147483638
APPQOSSYS 31
ORACLE_OCM 21
WMSYS 32
USERNAME USER_ID
------------------------------ ----------
DBSNMP 30
EXFSYS 42
ORDSYS 53
MDSYS 57
FLOWS_FILES 74
SYSTEM 5
SYS 0
JACK 85
MARK 86
USER1 84
SCOTT 83
33 rows selected.
SQL>
网友评论