iles off-line
7) Tried to take them online, got a message that recovery is needed. Recovered
datafiles
8) datafiles online, but still show 0 bytes
9) I was able to select and insert records into a table that uses this
tablespace.
Any idea will be greatly appreciated.
Thanks,
Gunawan Yuwono
Or
of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
=
Gunawan Yuwono
Oracle DBA
Kansas City, US
Try using FROMUSER/TOUSER when importing.
HTP.
Gunawan Yuwono
--- [EMAIL PROTECTED] wrote:
> Hi guys,
>
> 1. In my Oracle I have accounts : - teddy/bear (normal user can create)
> - sun/solaris (granted DBA role)
>
> 2. I run the catexp.sql
Just ignore this error message. It just means that the script's trying to
create a role that already exists. You'll get some like this when you re-run
your catalog.sql, etc.
HTP.
Gunawan Yuwono
--- [EMAIL PROTECTED] wrote:
> Hi guys,
>
> I am using sys account to run cat
day != 'SUNDAY' THEN
;
END IF;
EXCEPTION
WHEN OTHERS THEN
;
RAISE;
END;
/
And submit this stored procedure as a job everyday at 10 PM:
INTERVAL = 'TRUNC(SYSDATE + 1) + 22/24'
Does this make sense?
HTP.
Gunawan Yuwono
Oracl
Cherie,
Since SEARCH_CONDITION is LONG datatype, before you run the query, do:
SET LONG 90
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, USA.
--- [EMAIL PROTECTED] wrote:
> One of our developers is wondering why they can't
> see all of their check constraint options when t
row.long_type_column ||
''', ''' || c_row.varchar2_type_column || ''');');
END LOOP;
END;
/
Just curious, cannot you use EXP/IMP utilities or COPY command for what you are
trying to accomplish?
HTP.
Gunawan Yuwono
--- "Johan Locke@i-Com
Please note that the HELP topics on 8.1.6 are a lot less than the ones on
8.0.6. And yes, 8.1.6 doesn't have INSERT topic in the HELP table.
You can load the ones missing on 8.1.6 using the scripts from 8.0.6. At least
that's what I did.
HTH.
Gunawan Yuwono
Oracle DBA
Kansas
Use Package to store related objects together. Also, Package can have not only
stored procedures, but also functions as well.
HTH.
Gunawan Yuwono
--- Rajeshwari <[EMAIL PROTECTED]> wrote:
> What is the main difference between Package and procedure ? When a
> package shoul
>the message BODY, include a line containing:
> UNSUB ORACLE-L
> > > >(or the name of mailing list you want to be
> removed from). You may
> > > >also send the HELP command for other
> information (like subscribing).
> > >
> > >
10 matches
Mail list logo