Hi,
what's the best method to
1) remove a user absolutely. I want to remove the user's tables, indexes,
... etc.
2) move a user absolutely to another tablespace.
Thanks,
Murat
--
Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda
Thank you, Lynda, it worked.
Aleem
-Original Message-
Sent: Saturday, October 05, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: ora-305500
It is the line that contains (--) in the beginning
--
Please see the official ORACLE-L FAQ: http://www.orafa
hi
well i think i did this once, you can read
the output of the SQL query into shell variables by
first redirecting the output of the SQL query to an
OS file and then reading the file and loading
the data in the file into shell variables.
/* here is sample code to redirect the output of sql q
I attended Cary's and Jeff's Hotsos Clinic last week. It was really
good. I wrote a short review, which probably doesn't do the course
justice, at the following URL:
http://www.oreillynet.com/pub/wlg/2111
I also wrote a short article last week about an aspect of Oracle's
newly-supported SQL92 jo
prefix it with sys.
ie:
EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE);
Yechiel Adar <[EMAIL PROTECTED]>wrote:
I think that this require a deeper investigation.Last night I tried to use alter system sql_trace=true and it did not workeither.I had to put sql_trace=true in init.ora
I think that this require a deeper investigation.
Last night I tried to use alter system sql_trace=true and it did not work
either.
I had to put sql_trace=true in init.ora and to bounce the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL
