 | | | contexts: getting DDL | contexts: getting DDL 2006-07-05 - By Laimutis Nedzinskas
Back
How to get DDL for contexts?
recently we had to import/export schema which made use of contexts
(create or replace context ..., etc)
Oracle is 9i.
imp/exp did not catch contexts which seems to be some kind of
over-schema beast.
Oracle OEM Label Security GUI tool does not have any "extract DDL" too.
Is there anything else simple enough to use in everyday's life?
Thank you in advance,
Laimis N.
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: ORA-01940 (See http://ORA-01940.ora-code.com): cannot drop a user that is currently
connected</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff size=2>How
to
get DDL for contexts?</FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2>recently we had to import/export schema which made use of contexts
(create or replace context ..., etc)</FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff size=2
>Oracle
is 9i.</FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2>imp/exp did not catch contexts which seems to be some kind of over
-schema
beast.</FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff size=2
>Oracle
OEM Label Security GUI tool does not have any "extract DDL"
too.</FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff size=2>Is
there anything else simple enough to use in everyday's life?</FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006></SPAN><SPAN class=798281510-05072006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff size=2>Thank
you in advance, </FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff size=2
>Laimis
N.</FONT></SPAN></DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=798281510-05072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<P><SPAN
style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Arial"><BR>Fyrirvari
/Disclaimer<BR><A
href="http://www.landsbanki.is/disclaimer"><SPAN
style="COLOR: gray">http://www.landsbanki.is/disclaimer</SPAN></A><o:p></o:p><
/SPAN></P>
</BODY></HTML>
|
|
|