骛之网, Our Union, Doing Something !

Oracle中快速删除某个用户下的所有表数据

Author：Ouds Posted At : May 10, 2011, 11:18 a.m. Edited At : May 10, 2011, 11:18 a.m.
Catalog : 数据库【Database】 URL：http://Ouds.biz/blog/2011/05/10/oracle-clean-data-user/

一、禁止所有的外键约束

在pl/sql developer下执行如下语句：
SELECT 'ALTER TABLE ' || table_name || ' disable CONSTRAINT ' || constraint_name || ';' FROM user_constraints where CONSTRAINT_TYPE = 'R';
把查询出来的结果拷出来在pl/sql developer时执行。
若没有pl/sql developer，可以在sqlplus里操作，方法如下:
1. 打开sqlplus，并用相应的用户连接。
2. 把pagesize设大点，如set pagesize 20000
3. 用spool把相应的结果导到文件时，如
SQL> spool /home/oracle/constraint.sql
SQL> SELECT 'ALTER TABLE ' || table_name || ' disable CONSTRAINT ' || constraint_name || ';' FROM user_constraints where CONSTRAINT_TYPE = 'R';
SQL> spool off
4. 已经生成了包含相应语句的脚本，不过脚本文件里的最前和最后面有多余的语句，用文本编辑器打开，并删除没用的语句即可
5. 重新用相应的用户登录sqlplus，执行如下命令
SQL> @/home/oracle/constraint.sql

二、用delete或truncate删除所有表的内容

SELECT 'DELETE FROM '|| table_name || ';' FROM USER_TABLES
ORDER BY TABLE_NAME;
或
SELECT 'TRUNCATE TABLE '|| table_name || ';' FROM USER_TABLES
ORDER BY TABLE_NAME;
用第一步类似的方法操作。要注意的一点是，若表的数据有触发器相关联，只能用truncate语句，不过truncate语句不能回滚，所以时要注意

三、把已经禁止的外键打开

SELECT 'ALTER TABLE ' || table_name || ' enable CONSTRAINT ' || constraint_name || ';' FROM user_constraints where CONSTRAINT_TYPE = 'R';

Tags : Android, 竖屏, Oracle, 清除表数据, delete, truncate Comments(820) Read(4235)

Comment List

buy levitra Commented At May 18, 2012, 5:32 p.m.

buy levitra online no prescription - generic levitra online

URL：http://www.cecenter.org/about/

buy cialis Commented At May 18, 2012, 9:30 a.m.

cialis - generic cialis

URL：http://www.king-cat.net/history.html

buy viagra Commented At May 18, 2012, 1:18 a.m.

buy cheap viagra - generic viagra online

URL：http://hikenj.net/parks/

uzuzjua Commented At May 13, 2012, 7:14 p.m.

1FuOSS <a href="http://nwmweolflura.com/">nwmweolflura</a>, [url=http://yindxwagjrzx.com/]yindxwagjrzx[/url], [link=http://irfuwtzoshrx.com/]irfuwtzoshrx[/link], http://wjpffdaubaxn.com/

URL：http://wbovrswlrefq.com/

Zootslodo Commented At May 9, 2012, 1:40 a.m.

http://genericpercocet.name
<a href=http://genericpercocet.name>generic percocet</a>
<a href="http://genericpercocet.name">generic percocet</a>

URL：http://genericpercocet.name

buy viagra Commented At May 8, 2012, 11:08 a.m.

buy viagra online - generic viagra online

URL：http://independenceamerica.com/politics/

cvpokw Commented At May 6, 2012, 10:26 p.m.

quFMHW <a href="http://wnjxusyonqre.com/">wnjxusyonqre</a>, [url=http://kjnifpdtdqzg.com/]kjnifpdtdqzg[/url], [link=http://ctmcvlhyxtgb.com/]ctmcvlhyxtgb[/link], http://avhqkuckogmb.com/

URL：http://kmozexzcmggu.com/

mpdisnloeaj Commented At May 6, 2012, 10:05 p.m.

L6JXZ2 <a href="http://iavhlqilzdti.com/">iavhlqilzdti</a>, [url=http://gmqopmzwfrdj.com/]gmqopmzwfrdj[/url], [link=http://zcwdoibxhxac.com/]zcwdoibxhxac[/link], http://ncfyxriaraex.com/

URL：http://zwtkhdnwidgs.com/

awjgran Commented At May 6, 2012, 1:52 p.m.

gWzuo7 <a href="http://sjtlsmtrwggw.com/">sjtlsmtrwggw</a>, [url=http://zrawmsvocyok.com/]zrawmsvocyok[/url], [link=http://hjzblbpodzey.com/]hjzblbpodzey[/link], http://pizbnbkdbvti.com/

URL：http://jylswmljjkdl.com/

Zootslodo Commented At May 4, 2012, 5:18 a.m.

http://xanax.name
<a href=http://xanax.name>xanax</a>
<a href="http://xanax.name">xanax</a>

URL：http://xanax.name

Lavonn Commented At April 28, 2012, 11:14 p.m.

car insurance in florida 8))) what is prednisone used for qzqudz california health insurance 844499 cialis mgi

URL：http://www.sustcedu.com/Life-Insurance-Quotes.html

uipqzi Commented At April 18, 2012, 12:38 p.m.

etaxlri

URL：http://qenzwt.com/

Brandice Commented At April 11, 2012, 1:54 p.m.

cheap auto insurance quotes sepx mail order viagra iqn cialis nrn

URL：http://www.freequotesfast.net/

HofOffida8519 Commented At April 8, 2012, 12:01 p.m.

mittel gegen impotenz
psychische erektionsstorung
erektionsstorungen psychisch

http://www.erectile-dysfunctlon.com/index.php?lng=de&cv=eu
naturliches potenzmittel
erektionsstoerungen
was hilft bei impotenz

URL：http://www.erectile-dysfunctlon.com/index.php?lng=de&cv=eu

Buy viagra online Commented At April 3, 2012, 11:18 a.m.

, Levitra online without prescription, :-OO, Generic viagra online, >:]], Viagra, bvqvt, Viagra online, szskt, Viagra, 8OOO, Cialis online, :-DDD, Cheap viagra, 8548, Viagra online, 6340, Viagra online, >:-(,

URL：http://www.viagraonlinewithoutprescriptionusa.biz/

Carlie Commented At April 2, 2012, 8:58 p.m.

cheapest auto insurance >:[ auto insurance 862937 car insurance qoutes lrsqi

URL：http://www.allhealthinsurers.net/

Jennabel Commented At April 2, 2012, 5:13 p.m.

free car insurance quotes idwyr free auto insurance quotes 8))) auto insurance quotes 357391 cialis %-))

URL：http://www.car-insur-online.com/

Cialis online Commented At April 2, 2012, 4:12 a.m.

, Sildenafil online, 8((, Cheap cialis, :-OO, Viagra, 250445, Viagra, >:-[[, Buy viagra online, =-P, Discount viagra, djivni, Viagra for sale, >:-]]], Buy generic viagra, %-(, Buy cialis, 4707,

URL：http://www.cialisonlinews.com/

Cialis online cheap Commented At April 1, 2012, 10:28 p.m.

, Cheap viagra online, =), Viagra, slbr, Viagra cheap, 8(, Viagra, attmk, Cialis online, bhskw, Generic viagra, :O, Viagra, 57605, Cheap viagra, 35005, Buy cialis online, %],

URL：http://www.cialisonlineww.com/

Discount viagra Commented At April 1, 2012, 2:17 p.m.

, Viagra, %D, Cialis generic, lqtfa, Online viagra, 9324, Buy cheap viagra, imwe, Cheap viagra, agvo, Viagra price, 5044, Viagra price, iyiq, Buy discount viagra, swnf, Cialis, %],

URL：http://www.cheapviagrasw.com/

Viagra online withou Commented At March 31, 2012, 6:47 p.m.

, Levitra cialis viagra, 9198, Online viagra, 55469, Buy viagra, eysrv, Viagra, %-PP, Cialis vs viagra, gyyan, Viagra online, jsfs, Cheap cialis, 084827, Generic viagra online, :-], Viagra, >:),

URL：http://www.viagraonlinewithoutprescriptionusa.com/

Viagra online withou Commented At March 31, 2012, 6:46 p.m.

, Levitra cialis viagra, 9198, Online viagra, 55469, Buy viagra, eysrv, Viagra, %-PP, Cialis vs viagra, gyyan, Viagra online, jsfs, Cheap cialis, 084827, Generic viagra online, :-], Viagra, >:),

URL：http://www.viagraonlinewithoutprescriptionusa.com/

Viagra Commented At March 31, 2012, 8:38 a.m.

, Levitra, 419874, Discount viagra online, sqsddp, Buy viagra, %))), Buy viagra online, ssj, Viagra, %], Cheap cialis, :-OOO, Viagra online, 3857, Cheap viagra, jppftn, Viagra, 8P,

URL：http://www.genericviagraonlineusa.com/

Cheap viagra Commented At March 31, 2012, 5:52 a.m.

, Cheap viagra, >:O, Cheap viagra, hdt, Viagra, 9117, Viagra online, 4290, Cialis online cheap, ybspcv, Viagra, scr, Generic viagra, 871, Generic viagra online, 018, Cialis, 96029,

URL：http://www.cheapviagraws.com/

Viagra for sale Commented At March 31, 2012, 4:50 a.m.

, Generic cialis online, hariqz, Viagra, 663100, Buy cialis, 103, Order viagra, qzs, Viagra, 9391, Viagra for sale, :O, Viagra, 58674, Viagra, :-(((, Viagra online, %(((,

URL：http://www.genericviagrast.com/

AbatarNOulq Commented At March 31, 2012, 2:26 a.m.

Деловое предложение администратору ouds.biz

Ваш сайт - ouds.biz показался мне очень привлекательным и перспективным.
Хочу приобрести рекламное место для баннера в шапке Вашего сайта.
Какова будет стоимость данной услуги?
Оплачивать буду через WebMoney, 50% сразу, а 50% через 2 недели.

И еще, адрес моего сайта http://megasto.com.ua/ - он не будет противоречть тематике Вашего сайта?

Напишите о Вашем решении мне на почту megasto.com.ua@gmail.com
Заранее благодарен за оперативный ответ.

URL：http://megasto.com.ua

Cialis generic Commented At March 31, 2012, 1:08 a.m.

, Cheap cialis, kfu, Viagra, 178881, Order cialis, :PPP, Order viagra, lkf, Viagra, 769, Order viagra, 334, Generic viagra, %DD, Viagra online, %(((, Cheap viagra, 253,

URL：http://www.genericcialisusa.com/

Viagra side effects Commented At March 30, 2012, 5:49 p.m.

, Cialis, jypg, Viagra, 8-(, Order cialis, =PP, Viagra, 09907, Viagra, 412426, Viagra vs cialis, ple, Viagra generic, >:(((, Buy viagra online, =[, Cialis vs viagra, 8-],

URL：http://www.viagragenericfast.com/

Viagra Commented At March 30, 2012, 5:23 p.m.

, Levitra, 9515, Online viagra, yxlmx, Generic viagra, =DD, Viagra, xdtuak, Viagra, 761, Generic viagra, 753259, Cialis online, bncwk, Viagra online cheap, hhfw, Discount viagra, hvra,

URL：http://www.viagraonlinewithoutprescriptionusa.com/

Viagra sales Commented At March 30, 2012, 5:12 p.m.

, Viagra online, pybt, Cheap cialis, 886759, Viagra online, 0508, Cheap viagra, 8-]], Buy viagra online, 8-[[[, Viagra viagra, :-P, Buy viagra cheap, 83458, Cheap viagra, 355347, Cialis online, nxhou,

URL：http://www.genericviagraonlineuk.com/

Order viagra online Commented At March 30, 2012, 4:39 p.m.

, Order levitra, qccp, Viagra, lanqi, Buy viagra, odx, Viagra, pmxe, Viagra online without prescription, %OOO, Cialis online, 5865, Online viagra, ibdbf, Viagra online pharmacy, >:PP, Viagra online, 265472,

URL：http://www.cheapviagraonlineusa.com/

Viagra Commented At March 30, 2012, 4:28 p.m.

, Cheap viagra, xpuiid, Cheap viagra, :-D, Online viagra, =-[, Viagra online, 298, Cialis online, ksndu, Viagra, 94031, Does generic viagra work, uovcjx, Generic viagra, uobg, Cialis vs viagra, gem,

URL：http://www.viagraonlinewwv.com/

Anonymity Commented At May 11, 2011, 9:13 p.m.

嗯，好，就这个呢

我是谁？ Commented At Sept. 11, 2008, 10:44 p.m.

生命就象一场梦，又何必分什么梦想的生活，本身就在做梦！

Monica Commented At Sept. 11, 2008, 10:27 p.m.

Dreams are the images, thoughts and feelings experienced while sleeping, particularly strongly associated with rapid eye movement sleep. The contents and biological purposes of dreams are not fully understood, though they have been a topic of speculation and interest throughout recorded history. The scientific study of dreams is known as oneirology.

URL：http://en.wikipedia.org/wiki/Dreams

Anonymity Commented At Sept. 11, 2008, 10:22 p.m.

Dreams can come true
Look at me babe if I'm with you
You know you gotta have hope
You know you've got to be strong
Move a step closer
You know that i want you
I can tell by your eyes
That you want me too
Just a question of time
I knew we'd be together
And that you'd be mine
I want you here forever
Gabrielle
Do you hear what I'm saying
Gotta say how I feel
I can't believe you're here
But I know that you're real
I know what I want
And baby it's you
I can't deny my feelings
'Cos I know they are true
I've seen you sometimes
On your own and in crowds
I knew I had to have you
My hopes didn't let me down
Now you're by my side
And I feel so good
Don't fee; that ui ever could
Do you hear what I'm sayingh
Gotta say how I feel
I can't believe you;re here
But I know that you're real
I know whgat I want
And baby it's you
Can't deny my feelings
Because they are true
I'm not making plans for tomorrow
Let's live for tonight
I kknow I want you baby
So hold me so tight
Put your arms around me
You make me feel so safe
Then you whisper in my ear
That you're here to stay

长弓骛之 Commented At Sept. 8, 2008, 2:36 p.m.

LIFE IS A DREAM

LIFE IS A DREAM was published in 1636 or 1637 before Calderon was forty. Inasmuch as plays in seventeenth century Spain were written primarily for immediate production it is probable that this play had been presented on the Madrid stage before that date.

THE horoscope of the infant Prince, Segismund, convinces the Polish King, Basilio, that Segismund is destined to bring dishonor on Poland and downfall to his father, Basilio. He therefore announces that Segismund has died with his mother in birth. Confined in a tower, deep in the rocky fastnesses of the frontier, Segismund grows to manhood chained like an animal to a ring in the floor, guarded under direction of Basilio's confidential general, Clotaldo.

As the play opens two strangers whose storm-frighted horses have bolted, stumble on Segismund's prison. One of them confesses in a voice all too gentle for her masculine attire that she has come from Muscovy on a matter of vengeance and Segismund, for the moment unguarded, confesses that he too, thinks often on revenge. Clotaldo's appearance is about to result in death for the newcomers when the general recognizes the stranger's sword as one he had left years before in Muscovy as pledge for favor owed. The stranger identifies herself as Rosaura, daughter of Clotaldo's quondam benefactor, and is proffered safe conduct to Warsaw.

Meanwhile the King has Segismund brought to court while in a drugged sleep, to wake to all the appearances of royal splendor. His tragic story is related to him, he meets his cousins, Astolfo and Estrella, and falls promptly in love with the latter. When, however, his father, the King, appears, his desire for revenge on an unnatural father is too strong and he would have attacked the King had not the guards prevented. For this action he is returned in a drugged sleep to his prison and the King prepares to carry out his plans to marry his nephew, Duke Astolfo of Muscovy, to his niece, Estrella, and turn over his kingdom to them.

Meanwhile, back in the prison, Segismund is convinced by Clotaldo that the entire day's happenings are but a dream. Clotaldo nevertheless chides him for his unprincelike lack of self-control so effectively that when later in the day he is rescued by revolting Polish troops directed to his prison by Rosaura, he treats the vanquished King with great nobility and returns to him his forfeit crown. When he discovers that Astolfo has broken his engagement to Rosaura in hopes of gaining the Polish crown through marriage to Estrella, he dissolves the new bond, returning Astolfo to Rosaura and claims Estrella for himself.

URL：http://www.theatrehistory.com/spanish/calderon002.html

Previous Oracle中计算lob字段大小（bytes长度） Next Android中关闭程序/退出当前程序的7种操作方法

Catalog

Last Posts