• http://www.secret.pe.kr/19218
  • http://www.secret.pe.kr/5186
  • http://www.secret.pe.kr/19250
  • http://www.secret.pe.kr/19223
  • http://www.secret.pe.kr/5249
  • http://www.secret.pe.kr/4975

2018.06
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







[레벨:30]시크리트
조회 수 : 6084
2012.03.22 (14:56:23)


. Export, Import Utility는 이기종 플래폼에서 운영되는 Database 간의 데이터를 쉽게 이동 시킬수 있는 간단한 방법을 제공
. Export Utility는 Object Definition, table Data 등 추출하여 Binary 형태의 Dump 파일을 생성
. Import Utitity 는 Export 에 의해 생성된 Dump 파일을 Database로 Import 시킨다. Export 에 의해 생성된 파일 이외의 다른 파일은 사용할수 없다.
. Export, Import Utitity는 Database Backup/Recovery에 사용되어 될 수 있다.


- 언제 Export , Import 를 사용하는가?
. 테이블 재 구성 - Row Migration 이 많이 발생한 경우, 빈 Block, Fragmentation이 많을 경우 경합을 최소화 같은 경우 사용
. 사용자간 데이터 이동
. 데이터 베이스간 데이터 이동
. 다른 플래폼 또는 다른 버젼으로 데이터 이동 - upgrade 등 ....
. Logical BackUp시

- Export , Import 사용
. Exprot , Import를 사용하기 생성해야 하는 view가 있는데 catexp.sql을 실행하면 된다. 일반적으로 Database를 생성할때 catalog.sql이 실행 catexp.sql은 catalog.sql에 포함됨 (/oracle/홈/RDBMS/ADMIN 에 존재)
. Export, Import는 command interactive, graphic
. 공통적으로 사용되는 Parameter는 Paramete 파일에 지정
  - > parameter 파일은 name=values의 형태를 가진다.


■ Export Paramger
- userid : EXPORT를 실행시키고 있는 username/password명.
- buffer : 데이터 행들을 가져오는데 사용되는 버퍼의 크기.
- file : 생성되는 EXPORT덤프 파일명.
- filesize : EXPORT덤프 파일의 최대 크기
- grants : 데이터베이스 객체에 대한 권한 정보의 EXPORT여부 (Y/N 플래그)
- indexes : 테이블에 대한 INDEXES의 EXPORT여부 (Y/N 플래그)
- rows : 행들에 대한 EXPORT여부. (Y/N 플래그)
만약 “no”이면 데이터는 EXPORT되지않고 테이블의 정의만 EXPORT 됩니다.
- constraints : 테이블에 대한 제약조건 정보의 EXPORT여부 (Y/N 플래그)
- compress : IMPORT에 대비하여 테이블의 데이터를 한 extent로 압축 할것인가의 여부
(Y/N 플래그)
- full : 전체 데이터베이스를 EXPORT할것인가의 여부 (Full Level Export) (Y/N 플래그)
- owner : EXPORT될 데이터베이스의 소유자명 (User Level Export)[owner=user]
- tables : export될 테이블의 리스트(Table Level Export) [tables=(table1, table2, ...)]

- Table Level Export 
. 명시된 테이블만 엑스포트 됩니다. 
. 테이블의 구조, 인덱스, 권한등이 테이블과 함께 엑스포트 됩니다.

- User Level Export
. 사용자 객체들이 엑스포트 되고 객체들 안에 있는 데이터도 엑스포트 됩니다.
. 사용자 객체에 대한 모든 권한들과 인덱스들도 엑스포트 됩니다.
. 다른 사용자들의 객체와 권한, 인덱스들은 엑스포트 되지 않습니다.

- Full Level Export 
. 전체 데이터베이스가 엑스포트 됩니다. 
. 모든 테이블스페이스, 모든 사용자, 또한 모든 객체, 데이터들이 포함됩니다



- Table Mode (지정 테이블만 Export)
. parameter 파일 내용 (EXP1.PAR 만들어서 밑의 내용을 써라.)
FILE = expdat.dmp
TABLES = (scott.emp, scott.dept)
GRANTS = Y
INDEXES = Y

. 실행 
 - > exp system/manager parfile=exp1.par  (프롬프트 창에서 실행, 파라미터 파일을 미리 만들고 exp 명령 사용시)
 - > exp system/manager tables=(scott.emp,scott.dept) grants=y indexes=y (파라미터 파일 미사용시에는 옵션을 일일이 지정해야함)


- USER Mode (특정 사용자의 모든 테이블 백업)
. parameter 파일 내용 (EXP2.PAR 만들어서 밑의 내용을 써라.)
FILE=scott_all.dmp
OWNER=scott
GRANTS=Y
ROWS=Y
COMPRESS=Y

. 실행
 - > exp scott/tiger parfile=exp2.par


- FULL Mode (DBA 사용자가 모든걸 백업)
. parameter 파일 내용(EXP3.PAR 만들어서 밑의 내용을 써라.)
FILE=dba.dmp
GRANT=Y
FULL=Y
ROWS=Y

.실행
 - >exp system/manager parfile=exp3.par



 Import Parameter

- userid : IMPORT를 실생시키는 계정의 username/password명
- buffer : 데이터를 행들을 가져오는데 사용되는 buffer의 bytes수
- file : IMPORT될 EXPORT 덤프 파일명
- show : 파일 내용이 화면에 표시되어야 할 것인가를 나타냄(Y/N 플래그)
- ignore : IMPORT중 CREATE명령을 실행할 때 만나게 되는 에러들을 무시할 것인지 결정
(Y/N 플래그)
- indexes : 테이블 INDEX의 IMPORT여부(Y/N 플래그)
- rows : 테이블 데이터를 IMPORT할 것인가(Y/N 플래그)
만약 "N"로 설정하면 데이터베이스 객체들에 대한 DDL만이 실행됩니다.
- full : FULL엑스포트 덤프 파일이 IMPORT 할때 사용합니다.
- tables : IMPORT될 테이블 리스트
- commit : 배열(배열의 크기는 BUFFER에 의해 설정됩니다) 단위로 COMMIT을 할것인가 결정
기본적으로는 테이블 단위로 COMMIT을 합니다.
- fromuser : EXPORT덤프 파일로 부터 읽혀져야 하는 객체들을 갖고 있는 테이터베이스 계정
- touser : EXPORT덤프 안에 있는 객체들이 IMPORT될 데이터베이스 계정


- Import 예제
. parameter 파일 내용(IMP1.PAR 만들어서 밑의 내용을 써라.)
FILE=EXPDAT.DMP
SHOW=N
IGNORE=N
GRANT=Y
FROMUSER=SCOTT

. 실행
 - > imp system/manager parfile=imp1.par (파라미터 파일 있을시 파라미터 파일 지정)
 - > imp system/manager file=expdat.dmp fromuser=scott tables(dept.emp)


- 다른 계정으로 IMPORT하기
==> scott유저의 데이터를 EXPORT받아서 test 유저에게 IMPORT하는 예제 입니다.
C:\>exp userid=system/manager file=’C:\scott.dmp’ owner=scott
C:\>imp userid=system/manager file=’C:\scott.dmp’ fromuser=scott touser=test


- 전체 데이터베이스가 IMPORT됩니다. (Full Level)
C:\>imp userid=system/manager file=’C:\full.dmp’ full=y


- scott의 유저 IMPORT를 실행 합니다.(User Level)
C:\>
imp userid=scott/tiger file=’C:\scott.dmp’


참조 : http://onecellboy.tistory.com/entry/22-Export-Import



이 글의 테그에 포함되는 게시물 목록
  1. [2008/11/09] 하늘공원의 길 by 시크리트 (19368)
profile


삶이란 자신을 망치는 것과 싸우는 일이다
마음을 폐가로 만드는 모든 것과 싸운다

- 신현림 詩 '나의 싸움' 중에서...
2017.03.30 (15:49:16)
hyhMs

Scarpe Air Max

abercrombie and fitch store

Jordan Schoenen

Hugo Boss Sale

Boty Nike Air

Adidas Neo Discount Sale

Chaussure Nike Air Max Pas Cher

Cheap Michael Kors Tote Bag

zapatillas nike baratas

Michael Kors Handbags Discount

new yeezy shoes

suivre un envoi

Pandora Official Website

toms sale

Discount Air Max

converse store

Air Jordan Retro Sale

Vans Black Sneakers

Moncler Jackets Discount Marketplace

Ugg boots Sale

Adidas Shoes Discount Marketplace

uggs outlet

official NHL jerseys

religion store

adidas store

nike sb stefan janoski

Adidas Superstar Sale Online

retro jordans for cheap

Pandora Store

canada goose jacket outlet

Nike Air 90

Coach Bags On Sale

scarpe nike

zapatos de futbol nike

Original Ugg Boots

Ugg Pas Cher En France

scarpe hogan outlet

Soccer Boots Outlet nike

ugg store

christian louboutin outlet

womens nike air max

ugg clearance

fitflops sale uk

Nike Air Max Goedkoop

Uggs For Cheap

prada outlet

Stone Island Outlet

air force one pas cher

Ray Ban Sunglasses Online

23 IS BACK Store

Negozi Pandora

The official UGG

Nike Air Max Cheap

new jordan releases

Air Nike

vans shoe store

Canada Goose Outlet

Moncler Sale

chaussures nike pas cher

nfl store

Bottes Ugg Femme Pas Cher

Air Max Sneakers

Pandora Store

nike air jordan pas cher

Canada goose dam

nike joggesko

Nike Air Pas Cher

Ray ban sale online

Nike Online Store

Nike Air Sneakers

Nike Shoes Discount Marketplace

cheap uggs for women

TOMS SHOES OUTLET

adidas outlet

Nike Zapatos

Toms Outlet Online

Jordan Shoes Air

canada goose jackets on sale

Ugg Outlet Online Store

uggs for women

Doudoune Moncler Pas Cher

newest lebron shoes

chaussure Nike homme

Yeezy Black

Canada Goose Outlet

billige nike sko

goedkope nike air max

Air Max Pas Cher

Nike Shox Cheap

Jordan Sneakers For Sale

Air max levně

zapatilla adidas

Kobe Shoes Nike

Descuentos Nike

moncler jacket sale

Moncler Outlet Store

Nike Roshe Run Sale

Air Max 90

toms shoes outlet

nike air

Nike Factory Store

Nike Soccer Cleats Boots

Ugg Pas Cher Femme

Cheap Michael Kors

Jordan Store

Adidas Originals Stan Smith

cheap uggs

Uggs Pas Cher Soldes

Air Max Femme

nike schuhe günstig

Boutique Ugg

pandora jewelry store

Nike Air Jordan 11

ugg factory outlet

Hogan Outlet

nike jordan shoes

Boost Yeezy Sale On Line

Yeezy Men

coach factory outlet online

Timberland Outlet

hogan scontate

Ray-Ban Official Discounted Site

Michael Kors

nike air max running shoes

longchamp bags on sale

huarache sneakers

new pandora charms

Doudoune Moncler Femme Pas Cher

louboutin heels

pandora outlet store

nike mercurial soccer cleats

Pandora Store Sale

Nike Store

Doudoune Moncler Site Officiel

nike shoes

Adidas Superstar

Nike Shoes Sale Store

ADIDAS NMD SALE ON LINE

Nike Pas Cher Femme

cheap nike air max

chaussure basket homme

zapatillas running

Nike Shox discount Sale

Nike Air Women

Adidas Originals Superstar

Yeezy Boost Sale Online

pandora beads

günstige nike schuhe

botas de futbol

Oakley Sunglasses Cheap

moncler outlet

Nike Air Huarache For Sale

reebok running shoes

Canada Goose Womens Coats

Michael Kors Outlet

nike tn pas cher

Yeezy Shoes Discount Marketplace

UGG BOOTS FOR WOMEN

Nike Air Damen

Moncler Outlet Online

nike sportschuhe

Air Max Kopen

nike sneakers

Air max dam

hyhMs 2017.3.30
(*.163.211.6)
2017.08.25 (12:49:43)
HYst

"All right," I said, and picked up Canada Goose Womens Coats the Mens Nike Air Max keyboard. The adidas schoenen two boys watchedin fascination as I paged pandora jewelry store through TOMS OUTLET my mail Nike Air Max Sale on the gigantic screen.

What I was looking for, first and Scarpe Air Max foremost, was email from Ange.

There was a chance that she'd just gotten Boutique Ugg away. There was always thatchance.

I was an idiot to even hope. There was nothing canada goose jackets on sale from her. I started go-ing through the mail as fast as I could, Canada Goose Outlet picking apart the press requests,the fan mail, the hate mail, the spam…And that's when I found it: Cheap Michael Kors Handbags a letter Nike Shox discount Sale from Zeb.

"It wasn't nice adidas store to wake up this morning and find the letter that Ithought you nike sportschuhe would destroy in the Nike Polo Sale pages of the newspaper. Not nice atall. Made me feel — hunted.

"But I've come to understand why you Air Max Pas Cher did it. Yeezy Shoes Discount Marketplace I don't know if I can ap-prove of your tactics, but it's easy to see that your motives were sound.

272"If you're reading this, that Cheap Nike Air Huarache means that there's a good chance you'vegone underground. It's not easy. I've Nike Free Run 5.0 Womens been learning that. I've been learn-ing Nike Huarache Womens Cheap a lot more.

"I can help you. I should do that for you. You're doing what you canfor converse store me. (Even if you're not doing Ugg boots Sale it nike air with my permission.)"Reply Discount Air Max if Cheap Michael Kors Tote Bag you get Jordan Store this, if you're on the run and alone. Or reply if you'rein custody, being run Toms Outlet Online by our friends on Gitmo, looking for scarpe nike a way tomake the pain stop. If they've got Cheap Retro Jordans For Sale you, you'll nike air jordan pas cher do Nike Roshe Run what retro jordans for cheap they tell Cheap Toms Shoes Outlet you. Iknow that. I'll take that risk.

"For you, M1k3y.""Wooooah," Liam breathed. "Duuuuude." I wanted to smack him. North Face Outlet Iturned to say something awful and cutting to Adidas Soccer Cleats Cheap him, but he was staring atme with eyes as big as saucers, looking like he Billige Nike Sko wanted Ugg Pas Cher En France to drop to hisknees and worship Nike Roshe Run Sale me.

"Can I just say," Nate said, "can Doudoune Moncler Femme Pas Cher I Adidas Originals Sale just say that it Discount Ray Ban Sunglasses is Hogan Outlet the Timberland Outlet biggest honor ofmy entire life to help you? Can I just Ugg Pas Cher Femme say that?"I was Nike Air 90 blushing now. There reebok running shoes was nothing for Pandora Store it. Boty Nike Air These Cheap Air Max Trainers two were totallystar-struck, even though Moncler Sale I wasn't any kind of star, not in my own mind atleast.

"Can you guys —" I swallowed. Adidas Superstar "Can I have some privacy here?"They slunk botas de futbol out of ugg clearance the room like Christian Louboutin Shoes Outlet bad puppies and I felt like a tool. Ityped fast.

"I got away, Zeb. And I'm on Hugo Boss Sale the Zapatillas Air Max run. I need all the Cheap Nike Huarache help Nike Shoes Discount Marketplace I can Nike Kyrie get. Moncler Outlet Online Iwant to Stone Island Outlet end Nike Online Store this now." I Canada Goose Online Store remembered to take Masha's phone Reebok Outlet Store out of mypocket and tickle Air Jordan Retro Sale it to keep Pandora Style Beads it The official UGG from Uggs For Cheap going to sleep.

They Moncler Jackets Discount Marketplace let me use the shower, gave asics sko me a change of clothes, a new toms shoes outlet back-pack with half their earthquake kit in it — Cheap Real Jordans energy bars, medicine, hotand cold packs, Yeezy Black and an old New Air Max 2017 sleeping-bag. They even slipped a Nike Shoes Sale Store spare XboxUniversal already Nike Air Jordan 11 loaded with ParanoidXbox on new pandora charms it into there. That Michael Kors Handbags Discount was anice touch. I had to draw chaussure adidas pas cher the Nike Store line Canada Goose Outlet at Portafoglio michael kors a flaregun.

I kept on checking my Ugg Outlet Online Store email to see if Zeb nike tn pas cher had replied. I answered thefan mail. Negozi Pandora I answered the mail from prada outlet the press. 23 IS BACK Store I deleted the hate mail. Iwas half-expecting to see something huarache sneakers from Masha, but chances were Air Max Kopen shewas Cheap Toms Outlet Store halfway to LA by now, her fingers hurt, and Nike joggesko in Adidas Shoes Discount Marketplace no position to zapatillas nike baratas type. Itickled her phone again.

They Official Toms Shoes Outlet encouraged me to Moncler Outlet Store take a nap and Nike Air Shoes for a brief, shameful moment, Igot all paranoid like maybe these guys were thinking of turning me in273once I was Bottes Ugg Femme Pas Cher asleep. Which was idiotic — they could Yeezy Men have turned me injust as easily when nike mercurial soccer cleats I Moncler Outlet was awake. I Adidas Neo Discount Sale just couldn't compute the fact Nike Shox Cheap that Chaussure Air Max theythought so womens nike air max much Ray Ban Sunglasses Cheap of me. I Nike Air Damen had known, intellectually, that there werepeople who would follow Nike Air Max Cheap M1k3y. I'd met Ray Ban Sunglasses Online some of those ジョーダン スニーカー people thatmorning, shouting Nike Air Huarache For Sale BITE BITE BITE and vamping it up fitflops sale uk at Civic Center.

But these two were more personal. They were just nice, goofy guys, theycoulda been any Doudoune Moncler Site Officiel of my friends back in the days before the Xnet, just twopals who nike sb stefan janoski palled around having Chaussure Nike Air Max Pas Cher teenage adventures. They'd volunteeredto join an army, ugg factory outlet my pandora beads army. I had a responsibility to them. Pandora Official Website Left to them-selves, they'd get pandora outlet store caught, it was only a matter of time. They New Nike Shoes were Jordan Sneakers For Sale tootrusting.

"Guys, listen to me for Adidas Yeezy Boost 350 For Sale a second. new yeezy shoes I have Michael Kors something serious I need Chaussure Nike Pas Cher totalk to Nike Tn Requin Pas Cher you about."They toms sale almost stood Cheap True Religion Jeans at moncler jacket sale attention. It would have been funny if it wasn'tso cheap nike air max scary.

"Here's the thing. Now that you've helped me, it's really dangerous. Ifyou get caught, suivre un envoi I'll get caught. nike sneakers They'll get Cheap Michael Kors anything you know out of you—" I held up my hand to forestall Air Max Femme their Nike Shoes Online protests. "No, stop. You haven'tbeen through it. Everyone talks. Everyone breaks. Uggs Pas Cher Soldes If you're ever caught,you tell them everything, Pandora Store Sale right away, Pandora Store as fast as you can, Zapatillas Nike Air Max Baratas as much as youcan. They'll get it all Nike Air Sneakers eventually anyway. That's how they work.

"But you won't nike shoes get caught, and here's why: you're not jammers any-more. You are retired from Scarpe Nike Scontate active duty. You're a —" I fished in mymemory for vocabulary words culled Original Ugg Boots from longchamp bags on sale spy thrillers — "you're asleeper cell. new jordan releases Stand down. Go Coach Outlet Store Online back to being normal kids. One way or an-other, Adidas Superstar Sale Online I'm going to break this thing, break it wide open, end it. Air Max Sneakers Or it Nike Air Women willget me, finally, do me in. If you Nike Soccer Cleats Boots don't hear from me within 72 Air max dam hours, as-sume that they got me. Michael Kors Clearance Do whatever you want then. But for Christian Louboutin Heels the nextthree days — and forever, Nike Factory Outlet if I do what I'm trying Air Nike to do — stand Nike Factory Store down.

Will you promise me Nike Outlet that?"They promised with all Discount TOMS solemnity.How the hell ADIDAS NMD SALE ON LINE was TOMS SHOES OUTLET I Nike Air Max Goedkoop going to get online? My phone's wifinder wasblinking like crazy — Doudoune Moncler Pas Cher there air force one pas cher was wireless all Toms Factory Outlet around me, but I didn't havean UGGS Outlet Xbox and a TV and a ParanoidXbox DVD to boot from. WiFi, WiFieverywhere…That's when I spotted them. Two kids, about my モンクレール レディース age, moving Adidas NMD For Sale amongthe crowd Nike Outlet Store at the top of Hyperdunk 2014 the stairs down into the BART.

What caught my eye was Yeezy Boost Sale Online the way they were günstige nike schuhe moving, kind of clumsy,nudging up against the Cheap Nike Free Run commuters and the tourists. Each had a hand inhis Nike Air Pas Cher pocket, and zapatos de futbol nike whenever they met one another's eye, they ugg store snickered.

They couldn't have been more obvious jammers, but the crowd was obli-vious to them. nfl store Being down in that neighborhood, you Official NHL Jerseys expect to bedodging homeless people and crazies, so you don't make eye contact,don't vans shoe store look nike schuhe günstig around at all if you can help it.

I sidled Louboutin Wedding Shoes up to one. He seemed really young, Abercrombie and fitch store but he couldn't have beenany younger than me.

"Hey," I said. "Hey, can you Jordan Shoes For Cheap guys come over here for a second?"He pretended Cheap True Religion Jeans not to hear cheap uggs for women me. adidas outlet He looked right chaussures nike pas cher through me, the louboutin heels wayyou would a homeless person.

"Come on," I nike jordan shoes said. "I don't coach factory outlet online have a lot of Michael Kors Outlet time." Canada goose dam I grabbed his shoulderand hissed in Air Max 90 his ear. "The cops Descuentos Nike are TOMS For Sale after me. newest lebron shoes I'm from Xnet."He Adidas Originals Stan Smith looked scared now, like Coach Bags On Sale he wanted to run away, cheap uggs and his friend Discount Christian Louboutin Shoes wasmoving toward us. "I'm serious," Adidas Yeezy Cheap I said. "Just hear me Jordan Shoes Air out."His friend came Pandora Outlet over. He was taller, and beefy — christian louboutin outlet like Darryl. Cheap Air Max "Hey,"he said. Adidas Originals Superstar "Something wrong?"His Cheap Louboutin Heels friend whispered in his ear. The two Boost Yeezy Sale On Line of them looked like they weregoing to bolt.

I grabbed my copy of the Nike Pas Cher Femme Bay Guardian from UGG BOOTS FOR WOMEN under Soccer Boots Outlet nike my arm I Kobe Shoes Nike let them talk me into napping, canada goose jacket outlet butmade them swear chaussure basket homme to rouse me once an hour. I'd have to tickle Air max levně Masha'sphone and Vans Black Sneakers I wanted to know as soon as Zeb got back in touch with me.

(*.26.251.16)
문서 첨부 제한 : 0Byte/ 2.00MB
파일 크기 제한 : 2.00MB (허용 확장자 : *.*)
Tag List