s*******e
发帖数: 151 | 1 for personal use, it is ok. But you work in a company, do not do that. It
could cost a lot of money. |
|
s*******e
发帖数: 151 | 2 Yes, very expensive. I got a gerenal use one.It is more than $3000. |
|
e****e
发帖数: 1775 | 3 for example, i would like to generate insert and update statements for all
the tables in my db1 database. Need these scripts in other code.
Thanks.
Will do it in Toad. it's a vely basic & simple question.
any reply will be appreciated! |
|
c**t
发帖数: 2744 | 4 declare @sql varchar(1000)
set @sql='select * from TBALE'
execute @sql
for example, i would like to generate insert and update statements for all
the tables in my db1 database. Need these scripts in other code.
Thanks.
Will do it in Toad. it's a vely basic & simple question.
any reply will be appreciated! |
|
y****i
发帖数: 5690 | 5 I think the utility writes to relatively where the PL/SQL is executed. If you
are running it though TOAD but it's executing on the server, maybe it's trying
to write to the server.
If you use spool, I think you can change line size by
set linesize #
but I don't remember the limit of that number. |
|
f**y
发帖数: 26 | 6 其他的Oracle工具如果有能支持的也行。
多谢。 |
|
B*****g
发帖数: 34098 | 7 toad. but not sure if the trial version will allow you to export table
script. |
|
B*****g
发帖数: 34098 | 8 搞了一个admin_88的，不过只能用在toad9.5，其他的都不能用。我还是先观察一下再升
级吧 |
|
|
B*****g
发帖数: 34098 | 10 you use toad for sql server? |
|
f*****e
发帖数: 5177 | 11 I use it for Oracle/MySQL/SQLServer2000.
LZ ask for a free SQL server client. TOAD for SQL Server is free. |
|
B*****g
发帖数: 34098 | 12 哪里有toad free for sql server？ |
|
B*****g
发帖数: 34098 | 13 你说的free toad for sql server 在哪？ |
|
B*****g
发帖数: 34098 | 14 用起来怎样？有没有全套的toad可以用？呵呵
succ
o
on |
|
y********o
发帖数: 2565 | 15 No, I only have the free Toad. I have not tried 11g yet. |
|
B*****g
发帖数: 34098 | 16 ft, 10 seconds for google.
also find a trick I want to solve for a long time. |
|
c*******e
发帖数: 8624 | 17 try to add "top n" in your query
very
* |
|
s******r
发帖数: 1524 | 18 thanks,
"top n" does not work. where rownum |
|
|
|
k********e
发帖数: 702 | 21 哈哈， top n是 MS SQL
mysql 是 OFFSET m LIMIT n |
|
B*****g
发帖数: 34098 | 22 haha, I just play with bu guai |
|
|
|
|
B*****g
发帖数: 34098 | 26 hehe. I used sql developer before as previous job doesn't have toad license |
|
|
|
c*****d
发帖数: 6045 | 29 4肯定是最差
3应该比1快，如果col2, col3上有index估计就差不多了
在toad里执行一下，贴个执行计划看看
别直接贴在bbs上，上传附件比较清晰一些 |
|
B*****g
发帖数: 34098 | 30 没有import／export不能忍受，２００８exp版有这功能吗？２００８exp有external
table吗？如果用toad这些没有的功能能加上吗？
谢谢! |
|
|
|
|
|
y*h
发帖数: 107 | 35 我有个dump file, under my UNIX directory.
In addition, 我的co-worker gave me a script for dump file:
Imp ADAS_PROD_SUP/password file= |
|
|
e******r
发帖数: 220 | 37 I have a sample like this at hand.
EXEC DBMS_STATS.GATHER_TABLE_STATS(null,'JN_LINK_NAV_SPATIAL',estimate_
percent => 5, cascade => true);
thanks |
|
t*********i
发帖数: 217 | 38 this is a procedure GATHER_TABLE_STATS in package DBMS_STATS in SYS schema |
|
e******r
发帖数: 220 | 39 How to visit package DBMS_STATS in SYS schema? hehe
schema |
|
e******r
发帖数: 220 | 40 cool, got it , thanks a lot.
,
then |
|
|
j***a
发帖数: 10844 | 42 You can only see the procedure name and passing parameters of those packages
, but not the actual code because they are wrapped. |
|
e******r
发帖数: 220 | 43 let's say I have several tables, then after running some database
application (like ODBC),
How do I check which tables are populated ?
i.e. how to check which tables are modified and what kind of
modification they are.
thanks
|
|
|
t*********i
发帖数: 217 | 45 I mean, you can use F8 to recall SQLs you issued, but probably not from
applications. |
|
t*********i
发帖数: 217 | 46 Very good article. Saved. Thank you. |
|
e******r
发帖数: 220 | 47 如果我不是DBA, 我能AUDIT我自己的TABLE吗? 刚才试了一下, 好象不成 |
|
|
e******r
发帖数: 220 | 49 你是说可以? 不过我试了DBA_AUDIT_TRAIL好象我们oracle 10g不成啊.
audit table + trigger是啥意思?
再给指点一下吧? 我是analyst, 工作需要来临时研究DATABASE的.
谢谢 |
|
|
