请问, 如何查询出其他用户下的表结构 select * from user_tab_columns A,user_col_comments B where a.COLUMN_NAME=b.column_name and A.Table_Name = B.Table_Name 以上SQL可以查询出当前用户下的所有表的表结构, 我想请教一下, 如何把其他某个用户下的表结构查询出来...谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Connected as scott--直接导出表结构SQL> set pagesize 1000;SQL> set linesize 1000;SQL> set long 10000;SQL> select dbms_metadata.get_ddl('TABLE','EMP') from dual;DBMS_METADATA.GET_DDL('TABLE',-------------------------------------------------------------------------------- CREATE TABLE "SCOTT"."EMP" ( "EMPNO" NUMBER(4,0), "ENAME" VARCHAR2(10), "JOB" VARCHAR2(9), "MGR" NUMBER(4,0), "HIREDATE" DATE, "SAL" NUMBER(7,2), "COMM" NUMBER(7,2), "DEPTNO" NUMBER(2,0), CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ENABLE, CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "SCOTT"."DEPT" ("DEPTNO") ENABLE ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" select * from dba_tab_columns A,dba_col_comments B where a.COLUMN_NAME=b.column_name and A.Table_Name = B.Table_Name and a.OWNER=UPPER('你要查的用户名') --如果你具有dba权限的话,你可以在数据字典视图dba_tables里面找到:Connected as SYSSQL> select table_name 2 from dba_tables 3 where owner='SCOTT';TABLE_NAME------------------------------DEPTEMPBONUSSALGRADEGOODS_TB1GOODS_TB2BIN$sIAbxyySSR+bLoPn7LFWUw==$0PROJECT_MANAGEBIN$jnPSgJ6QSRWlwsLJZD//ew==$0SYS_TEMP_FBTBIN$5f+WRH2pRceSPdBdNzioaw==$0BIN$xtN2bVGDSbuIdwH0qNH53Q==$0BIN$2Ka/tO+NRHGEnVsTohJj0A==$0BIN$T36njRFDRaSDCWB/cfg9kA==$0TEMP_TABLE_SESSION15 rows selected orcle读取excel文件,excel版本是2010的报错无法正确执行 oracle 9i 怎样清除碎片 ORACLE 存储过程如何使用不定长数组参数???? oracle 查看系统定义异常的sql语句 晕了,请好心人帮帮忙!!!! 非常弱的问题,关于oracle得基本使用 急急急???在RH9下安装ORACLE8I数据库 oracle9i 安装问题. 弱弱的问题 求相对时间的问题 oracle中用户,表空间,数据库,数据文件,数据库表间关系 数据库空间满了怎么处理
Connected as scott
--直接导出表结构
SQL> set pagesize 1000;
SQL> set linesize 1000;
SQL> set long 10000;
SQL> select dbms_metadata.get_ddl('TABLE','EMP') from dual;DBMS_METADATA.GET_DDL('TABLE',
-------------------------------------------------------------------------------- CREATE TABLE "SCOTT"."EMP"
( "EMPNO" NUMBER(4,0), "ENAME" VARCHAR2(10), "JOB" VARCHAR2(9), "MGR" NUMBER(4,0), "HIREDATE" DATE, "SAL" NUMBER(7,2), "COMM" NUMBER(7,2), "DEPTNO" NUMBER(2,0), CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE,
CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "SCOTT"."DEPT" ("DEPTNO") ENABLE ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
A.Table_Name = B.Table_Name and a.OWNER=UPPER('你要查的用户名')
--如果你具有dba权限的话,你可以在数据字典视图dba_tables里面找到:
Connected as SYS
SQL> select table_name
2 from dba_tables
3 where owner='SCOTT';TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
GOODS_TB1
GOODS_TB2
BIN$sIAbxyySSR+bLoPn7LFWUw==$0
PROJECT_MANAGE
BIN$jnPSgJ6QSRWlwsLJZD//ew==$0
SYS_TEMP_FBT
BIN$5f+WRH2pRceSPdBdNzioaw==$0
BIN$xtN2bVGDSbuIdwH0qNH53Q==$0
BIN$2Ka/tO+NRHGEnVsTohJj0A==$0
BIN$T36njRFDRaSDCWB/cfg9kA==$0
TEMP_TABLE_SESSION15 rows selected