차세대나 개발DB 구축시에 기존에 있던 환경과 동일하게 구축하고자 할때 사용 하는 방법입니다.
간단한 쿼리를 이용해서 추출을 할 수 있습니다.
Set pages 500
Set line 500
Set long 20000000
select tablespace_name, dbms_metadata.get_ddl(‘TABLESPACE’,tablespace_name)||’;’ script
from dba_tablespaces
where tablespace_name in (‘TEMP’,’USERS’,’UNDOTBS1′,’SYSTEM’,’SYSAUX’); — 포함 시킬 Tablespace 기입
Nieruchomość przeznaczona jest do remontu.
It’s a shame you don’t have a donate button! I’d without a doubt donate to this outstanding
blog! I suppose for now i’ll settle for bookmarking and adding
your RSS feed to my Google account. I look forward to fresh
updates and will share this website with my Facebook
group. Talk soon!
What’s up Dear, are you truly visiting this web site daily, if so
then you will absolutely obtain nice knowledge.
Hello it’s me, I am also visiting this web site regularly, this website is really pleasant
and the viewers are in fact sharing pleasant thoughts.
When some one searches for his necessary thing,
thus he/she wishes to be available that in detail, thus that thing is maintained over here.
I’m extremely impressed with your writing skills and also with the layout on your
weblog. Is this a paid theme or did you customize it yourself?
Anyway keep up the excellent quality writing, it’s rare to see a nice blog like this one
nowadays.