dava | 17 十一月, 2006 10:34
Oracle的导出实用程序(Export utility)允许从数据库提取数据,并且将数据写入操作系统文件。exp使用的基本格式:exp[username[/password[@service]]],以下例举exp常用用法。
1. 获取帮助
exp help=y
2. 导出一个完整数据库
exp system/manager file=bible_db log=dible_db full=y
3. 导出数据库定义而不导出数据
exp system/manager file=bible_db log=dible_db full=y rows=n
4. 导出一个或一组指定用户所属的全部表、索引和其他对象
exp system/manager file=seapark log=seapark owner=seapark
exp system/manager file=seapark log=seapark owner=(seapark,amy,amyc,harold)注意:在导出用户时,尽管已经得到了这个用户的所有对象,但是还是不能得到这些对象引用的任何同义词。解决方法是用以下的SQL*Plus命令创建一个脚本文件,运行这个脚本文件可以获得一个重建seapark所属对象的全部公共同义词的可执行脚本,然后在目标数据库上运行该脚本就可重建同义词了。
SET LINESIZE 132
SET PAGESIZE 0
SET TRIMSPOOL ON
SPOOL c:seapark.syn
SELECT 'Create public synonym '||synonym_name
||' for '||table_owner||'.'||table_name||';'
FROM dba_synonyms
WHERE table_owner = 'SEAPARK' AND owner = 'PUBLIC';
SPOOL OFF5. 导出一个或多个指定表
exp seapark/seapark file=tank log=tank tables=tank
exp system/manager file=tank log=tank tables=seapark.tank
exp system/manager file=tank log=tank tables=(seapark.tank,amy.artist)6. 估计导出文件的大小
全部表总字节数:
SELECT sum(bytes)
FROM dba_segments
WHERE segment_type = 'TABLE';seapark用户所属表的总字节数:
SELECT sum(bytes)
FROM dba_segments
WHERE owner = 'SEAPARK'
AND segment_type = 'TABLE';
seapark用户下的aquatic_animal表的字节数:
SELECT sum(bytes)
FROM dba_segments
WHERE owner = 'SEAPARK'
AND segment_type = 'TABLE'
AND segment_name = 'AQUATIC_ANIMAL';
7. 导出表数据的子集(oracle8i以上)
NT系统:
exp system/manager query='Where salad_type=''FRUIT''' tables=amy.salad_type file=fruit log=fruitUNIX系统:
exp system/manager query="Where salad_type='FRUIT'" tables=amy.salad_type file=fruit log=fruit
8. 用多个文件分割一个导出文件
exp system/manager
file=(paycheck_1,paycheck_2,paycheck_3,paycheck_4)
log=paycheck, filesize=1G tables=hr.paycheck9. 使用参数文件
exp system/manager parfile=bible_tables.par
bible_tables.par参数文件:
#Export the sample tables used for the Oracle8i Database Administrator's Bible.
file=bible_tables
log=bible_tables
tables=(
amy.artist
amy.books
seapark.checkup
seapark.items
)
10. 增量导出
exp system/manager inctype=complete file=990702.dmp
exp system/manager inctype=incremental file=990702.dmp
exp system/manager inctype=cumulative file=990702.dmp
附:常用参数说明
| 参数 | 说明 |
| file | 指定导出文件名。默认值是file=expdat.dmp。默认的文件扩展名是.dmp |
| filesize | 允许使用多个文件分布式导出数据。默认值为filesize=0,表示所有的数据被写入一个文件。可以选filesize=1024(1K,1M,1G) |
| full | full=y时,表示整个数据库将被导出。默认值为full=n |
| help | 控制帮助屏幕的显示。它的参数是help=y;没有help=n选项 |
| inctype | 指定增量导出选项 |
| indexes | 指定索引是否被导出。默认值为indexes=y。如果不希望索引被导出,用indexes=n |
| log | 指定收集导出信息(包括任何错误信息)的逻辑文件名。默认的文件扩展名是.log |
| owner | 允许为指定用户或一列用户导出数据和对象 |
| parfile | 允许从一个文件读取导出参数 |
| query | 指定从一个或更多的表中导出行的一个子集。它的参数值在where语句中,并且被应用于select语句,在这里export不导出每一个表 |
| rows | 控制表数据是否被导出。默认值为rows=y,表示数据被导出。rows=n表示只想导出表定义,而不想导出表的数据 |
| tables | 允许导入一个指定的表或一列表 |
Tinyevedy | 28/01/2012, 18:58
adjubdida | 20/07/2010, 07:22
Das Team heisst alle willkommenn sämtliche unsere Kunden, als auch neue Klienten im bekanntesten Portal
[url=http://visitx.im-blog.de.im-blog.de]VISIT X[/url] in Frankfurt. Unsere Stamm Besucher brauchen wir nicht beträchtlich berichten, was das Portal anbietet .
ungeachtet allen unseren neuen Kunden möchten wir zum Fahrtbeginn unsere Besten Amateur Girls vorstellen, die mit Entzücken für euch einen eigens vorbereitet Performance vor der Cam zeigen. gleichartig ihr schon freudig bemerkt habt, geht das das Internetseite Visit x mit Hilfe von Video Übertragung. Unser Internetportal bringt die meisten ansprechend attraktiv reizend Girls vereint, die sich mit professionellen Auftritten vor den Cams beschäftigen.
aufgrund der Tatsache uns, könnt ihr an einem Bezirk 98 % der europaweiten Erotik Top Mädchen sehen. Jede der Amateur Girls besitzt ihre private Galerie mit erotischen Fotos und Videos. Um euch die Warenangebot zu lindern haben wir euch einen Text Chat zu Vorschrift gestellt der kostenlos ist. Nach dem ihr ein einige Chats mit eurem ausgesuchten Camgirls gesendet habt, könnt ihr die Abstimmung treffen, ob ihr die kostenpflichtige Möglichkeit von [url=visitx.jimdo.com]VisitX[/url] Studentinnen wählt und euch mit dem Studentinnen unter 4 Augen trifft, die euch am besten Anklang finden hat. Wir ersehnen euch eine gelungene Chats und laden wie immer alle ein um Visit x immer wieder zu besuchen.
berksad | 15/07/2010, 03:20
- 磬 桧蝈痦弪-漕耜
ToomtaveGeone | 05/07/2010, 16:05
[url=http://serenityfff.t35.com/1042860.html]恹耦觐
pauguriseerse | 03/07/2010, 07:25
pauguriseerse | 03/07/2010, 07:25
UnororyKeni | 28/06/2010, 00:51
桧蜩祉 珥嚓铎耱忄
Auctiocub | 20/06/2010, 07:54
Hello.
hukilxxxru
And Bye.
hinrustjum | 18/06/2010, 22:49
埋
sheelapentupt | 16/06/2010, 22:44
ckekAbsows | 21/05/2010, 10:59
Thank you very well read allss textt about drsating and ilike it very much
WGChristopher | 15/05/2010, 23:19
Hi everyone!
High Quality Bathroom Vanities at Affordable Prices http://www.listvanities.com/vanities-for-bathrooms.html
no taxes in the US
Itecruitued | 11/05/2010, 14:02
eixaldaSnowxie | 05/02/2010, 18:43
well hey there guys, i've been looking all over the internet for a GOOD black hat SEO forum.. I was looking for some suggestions
from you guys to point me in the right direction.
Thanks a bunch, this place is great btw.
wppppppzpppp | 05/12/2009, 08:20
逾噫噱禧
speaspKes | 27/11/2009, 23:57
frederick amateur radio club inc real amateur home sex tapes free live amateur webcams free porno teens videos free hardcore toon porn videos free monkey sex video free sex stories movie cl free samples dog sex movies free porn movie videos galeries free amateur adult videos free online ebony sex videos free homemade amateur videos free gay anel sex videos free bbw sex movie clip sexy erotic mature tube
JokeJurfire | 21/10/2009, 02:36
[quote]琼嚓铎耱忄 皴犟 漯箧徉
觌筢 桧蜩
DrEurope | 29/09/2009, 13:35
Hi, my name is Shanti Sherna from Ukraina. I'm 27 y.
I just love to read this forum articles & topics discussed here.
regards
Shanti,
malvinka | 11/09/2009, 07:05
卿疣怦蜮箝蝈.
margohelp | 11/09/2009, 06:47
had recently herpes virus found in my blood. what I haveto do??? I'm in panic...
zhemchug_[UIDIYUIFFIIU] | 07/09/2009, 16:08
橡桡豚屐 锣
jeoclodeaduro | 04/09/2009, 18:01
I was trapped in org one day.
I could not go out; I know I can take flight path then out.
I even have no copper in hand.
But I don't believe WOW-GOLD-TIP will come and get me out of the trouble!
In my real life I never experienced so bad things, so helpless and embarrassing.
I was trapped totally. And luckily, a guy from WOW-GOLD-TIP came,
I know he came here not to help me just passed by because I never bought WOW GOLD from [url=]www.wow-gold-tip[/url] ever before, however,
he did help me, even just give me a silver. I came out with the silver.
It never happened to me in my real life, when I think about it I wanna laugh at myself, too. Does that kind of embarrassing thing ever happen to u?
Anyway, I want to say thanks for that guy from WOW-GOLD-TIP, in the meanwhile, I tried to purchase on wow-gold-tip, the price there is just 7usd for each 1000G, it is the cheapest I've ever seen and the delivery finished in 15 minutes!
Thanks again,Wow-gold-tip!
drkevinonline | 01/09/2009, 21:23
Buy Oxycontin, buy Rohypnol, buy Dilaudid, buy TOQUILONE, buy GHB without prescription : drkevin@mail.ru
Plus many sorts of other pain meds!
WEEVAIDEALF | 27/08/2009, 15:30
囹
trimmer[POJTTPQQPTTP] | 27/08/2009, 01:30
橡桡豚屐 锣
rotthyday | 26/08/2009, 12:08
Viktor | 25/08/2009, 09:17
foorkderm | 14/08/2009, 11:23
湾 箐桠
XRumerTest | 11/08/2009, 08:46
Hello. And Bye.
allin | 29/07/2009, 22:04
橡邃豚汔
smafaging | 18/07/2009, 20:27
someone?
CocoChanels | 27/06/2009, 23:00
Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!
Astewjewinemn | 21/06/2009, 16:00
橡铖眢豚顸
Usemocoazom | 21/06/2009, 07:56
橡铖眢豚顸
Gundeflan | 11/06/2009, 06:35
I want to listen good music. Help me please.
alancactapips | 01/06/2009, 08:52
Sildenafil ist derd Frerinameeines Arzneistoffes, der1989 von der U-amerikanischen FRirma Pfizerunter dem Namen Viagra
| « | 一月 2012 | » | ||||
|---|---|---|---|---|---|---|
| 一 | 二 | 三 | 四 | 五 | 六 | 日 |
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 | |||||
Cheap tadacip online prescription purchase without, buy tadacip without prescription, order tadacip without prescription.