Submit My Question - Recent Questions - Recent Answer
Msdn China Tech >> Oracle >> 开发

如何通过sql方式得到表空间,表等的ddl?

我从网上找到一些东西，可调试不过!
[23 byte] By [freebob-bob] at [2007-12-16]
«« 能不能修改表中的字段名称?
»» oracle的随机帮助太不好用了,哪里有使用起来更方便的oracle帮助文档?请推荐,谢谢!
# 1
alter user username default tablespace tablespacename
alter uer username quota 100m on tablespacename
wwl007-疑难杂症 at 2007-10-23 > top of Msdn China Tech,Oracle,开发...
# 2
select * from user_tables;
select * from user_tablespaces;
这些数据字典中，完全可以得到任何信息。
xynet-xynet at 2007-10-23 > top of Msdn China Tech,Oracle,开发...
# 3
do remember to analyze your table first ( by analyze commond) , then all the information will be appears in user_segments , user_tables , user_indexes , user_tablespaces , v$datafile etc
black_snail-●男人要忍○ at 2007-10-23 > top of Msdn China Tech,Oracle,开发...
Oracle
开发

Oracle Hot Topic

Oracle New Topic

Oracle

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified