Ron,
Trunacte is DDL not DML. The easiest was around this is to wrap it in an
execute immediate command:
BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE LOT837_GLOBAL_TBL_KMG';
END;
/
Note that the semi-colon is outside the quotes - don't place a semi-colon
inside the quotes.
Regards,
Mark.
** Welcome to the Oracle-L Mailing List! **
Table Of Contents
-
1) Charter for this mailing list
2) Characteristics of this mailing list
3) How to submit a posting to the list
4) How to unsubscribe from the list
5) Commonly used mailing list server
Try 'set oracle-l nomail'
Jared
On Wednesday 05 February 2003 06:52, Ferenc Mantfeld wrote:
Hi All
my machine has been rebuilt, with my outlook file lost, thus I do not have
the mail that describes how to set my account not to receive mail until I
say so. I sent a message to [EMAIL
Use:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 9:52 AM
Hi All
my machine has been rebuilt, with my outlook file
it should be set oracle-l NOMAIL
deb
From: Ferenc Mantfeld [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: help set nomail
Date: Wed, 05 Feb 2003 06:52:21 -0800
Hi All
my machine has been rebuilt, with my outlook file lost,
What is your TAR number?
Hi guys, I need help!
At this moment, it doesn't matter how I messed everything
up, but Development server is down.
Had to recover operating system with a two month old
backup. Oracle motor resides in the MkSysB backups, so
some files where replaced, some datafiles
Veronica Levin wrote:
Hi guys, I need help!
At this moment, it doesn't matter how I messed everything up, but
Development server is down.
Had to recover operating system with a two month old backup.
Oracle motor resides in the MkSysB backups, so some files where replaced,
some datafiles
Run GRANT EXECUTE ON SYS.DBMS_PROFILER TO you first; it appears that
your permissions were granted through a role...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 4:59 AM
Hi,
I need to use the DBMS_PROFILER package
Satya,
pls grant the privileges from sys to the user running the DBMS_PROFILER package
Venkat
--
On Thu, 23 Jan 2003 03:59:00
Satya V Prakash wrote:
Hi,
I need to use the DBMS_PROFILER package for PL/SQL
in between the procedures. I used the corresponding script located
in
Hi,
Please ask the DBA to check whether the self checking by dbms_profiler
was completed.
The package upon completion should give SYS.DBMS_PROFILER
successfully loaded.
Also please grant execute privilege on DBMS_PROFILER to the user .
Pradeep
Hi Venkat and group,
Thanx for ur replies,
It worked !! U were right.
I now connected as sys and granted permission for my user, ran the
script(PROFTAB.sql),
The table- plsql_profiler_data is now created !
Regards,
Satya Prakash
On Thu, 23 Jan 2003 C.S.Venkata Subramanian wrote :
Satya,
bryan!
please provide the errors, you can query them with
SHO[W] ERR[ORS] ...
daniel
Bryan, Miriam wrote:
Hi List, I'm hoping someone can help me. I'm trying to compile a procedure,
which calls another procedure and I keep getting an error on the first end;
can't figure out what's
Title: RE: Help with procedure
There is a END IF missing before the EXCEPTION ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc
Miriam,
alaong with what everyone else sad, your loop control is wrong.
you said:
FOR x IN get_workgroups
this is not referencing your cursor properly. you named your cursor
get_admin.
the FOR statement should be:
FOR x in get_admin
hope this helps.
Tom Mercadante
Oracle Certified
Thanks to everyone that was gracious enough to take the time to look into my
procedure. IT WAS the ELSE IF statement, which I would've noticed it I
wouldn't have been in such a rush!
Thanks Again,
M. Bryan
-Original Message-
Sent: Monday, January 20, 2003 4:47 PM
To: Multiple
-
From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help with procedure
There is a END IF missing before the EXCEPTION ...
Raj
Could you relate exactly what error you are seeing? Just seeing the code
doesn't help much...
To get the error messages, you can execute the following from SQL*Plus:
SHOW ERRORS PROCEDURE PROCEDURE CONVERT_AA_ADMIN
while connected as the account EMPLOYEE_ACTIVITY...
- Original Message
What is the exact error? What oracle version? Just guessing, are the privs
granted directly to the user or through a role? If they are via a role,
grant them directly to the user...
HTH
Tim
-Original Message-
Sent: Monday, January 20, 2003 4:16 PM
To: Multiple recipients of list
Was this it? http://www.orakle.com/
Greg
-Original Message-
Sent: Thursday, January 16, 2003 5:29 AM
To: Multiple recipients of list ORACLE-L
A while back I posted a link to a website that has hundreds of Oracle links.
It's a site that is good for Unix and Windoze bigots, pick your
This is great. I was wondering what happened to Atul's page.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 7:43 AM
Was this it? http://www.orakle.com/
Greg
-Original Message-
Sent:
Dave,
Is this the one that you were looking for. I don't recall where I picked it
up from but it was probably this list
http://www.orakle.com/
John
-Original Message-
Sent: 16 January 2003 10:29
To: Multiple recipients of list ORACLE-L
A while back I posted a link to a website that
I don't know if this is it but, I find the following very useful:
Atul Mehta's o r a c l e World
http://www.orakle.com/
-Original Message-
Sent: Thursday, January 16, 2003 5:29 AM
To: Multiple recipients of list ORACLE-L
A while back I posted a link to a website that has hundreds of
Title: Message
Dave,
Was it this one? You might be able to find what you need at this
site. http://web.singnet.com.sg/~petermag/oracle.html Dave-Original
Message-Sent: Tuesday, October 22, 2002 8:39
PMTo: Multiple recipients of list
ORACLE-LSHi,Does anyone know of any web site that
That is not the specific one I had but it looks good.
thanks,
Dave
-Original Message-
Sent: Thursday, January 16, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L
Was this it? http://www.orakle.com/
Greg
-Original Message-
Sent: Thursday, January 16, 2003 5:29 AM
To:
Dave:
Sorry about your drive.
Obvious solution -- drink more beer.
Barb
--
You might be able to find what you need at this site.
http://web.singnet.com.sg/~petermag/oracle.html
Dave
--- Farnsworth, Dave
[EMAIL PROTECTED] wrote:
A while back I posted a link to a website that has
-Obvious solution -- drink more beer.
Best tip I've read all day, I will take your advice.
Dave
-Original Message-
Sent: Thursday, January 16, 2003 9:25 AM
To: Multiple recipients of list ORACLE-L
Dave:
Sorry about your drive.
Obvious solution -- drink more beer.
Barb
--
You
Title: Message
YES
YES YES YES YES YES YES YES YES YES YES YES YES
YES
That's the
one!!
Thanks,
Dave
-Original Message-From: Sherman, Edward
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 8:35
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
HELP
Title: Message
WOW
this is awesome! I hope a lot of these links are still alive. Thanks for
sending this.
-Original Message-From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16,
2003 10:50 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: HELP
Hi Raja Kumar,
If you don't know what are the differences use the parameters touser and fromuser
During importation
Oracle will recreate those tables
I think if you not use the ignore = y you will get error message since Oracle cannot
insert due to different table structure
Just guessing
If
The best method that I know is:
1) export from production.
2) drop user cascade in development or at least drop all tables.
3) create user in development.
4) import into development with indexes=n and constraint=n.
5) import again into development with rows = n and ignore = y.
Step 4 will build
To fine tune the suggestions aready made, you probably don't want to drop
all the table but just tables both in production and development/test. I
would create a list of tables exported from production via export / show and
use this to create a drop table script.
Mike
-Original
You will need to apply the structural changes before
importing for existing tables. If you want to make a
test db as copy of original one try cloning! It is
easy and quick.
--- [EMAIL PROTECTED] wrote:
I have 2 8i database out of which one is production
and the other is for
development and
Amar - I was just thinking about suggesting. And as a bonus, you can test
your backups, always a good idea.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 06, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L
You will need
Title: RE: Help with IMPort
Yeah ... yeah ... but after cloning will you submit the databases for a DNA test to prove that it is a true clone?
Oops ... Sorry ... I almost forgot we are talking databases here ... is cloning legal yet?
Raj
Dennis, Amar -
My interpretation of the environment was that dev/test has a different set
of tables, some of the tables match production table names but may not have
the same columns or data. In this case, my first suggestion to drop
matching table names from dev/test is insufficient. Maybe
Michael - Yeah but the developers are always whining about something anyway
:-) Just kidding. Yes, timing of the refresh can be an issue. We are looking
toward a staging environment. Now that will be identical to production. Then
we can execute a script that will create or modify tables and other
Title: RE: Help with Import
Dennis,
We do almost the same thing that you described.
We have a 140G database. Everyday we *clone* that production database and call it 'DAYOLD'. This database is used by app support to investigate data related issues and bugs. But a day before release, we
Raj - Thanks for sharing the details of how this method works in practice
for you.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 06, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Dennis,
We do almost the same
:
Sent by: Subject: RE: Help with Import
[EMAIL PROTECTED
1) You can delete ONLY in the leaf level in the Oracle Directory Manager.
Been there done that.
2) There is a script oracle_home\ldap\bin\bulkdelete.sh that is supposed
to do what you need.
It is .sh even in windows systems so you need something like cygwin to run
it.
I did not succeed to run and
Thanks for your suggestion, i checked that article, but still unable to solve the
problem.
The same time the next day, another instance in the cluster died, with the same
reason. ora-29740, still with reason 2.
The cluster runs quite stable in the past month(since the patchset is installed, it
Thanks for friends,
I found the reason of my rac down.There is a cron that runs daily to sync the
time with the time server. My sa added it without telling me.
And if i set the time back in one node, the instance on another node went
down, with the same trace information. I
Hi Chao:
THe Instance 2 in your Cluster (rac2) was dead during
the fast reconfiguration (Check the reason in the alert log
file.. which says reason 2). You generally do a reconfig
(or fast reconfig) when you add/remove instances from the
Cluster setup, which is not (I hope) in your case.
THere
Title: RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB
if you have activex controls that you want to replace, there is 'Java Importer' and in Forms 9i you can use PJCs also.
Read through Forms information at http://technet.oracle.com
Raj
Title: RE: Help Urgent Where is Tablespace Manager??
Well I installed Version 2.2 of OEM and 9i OEM until I can figure this out in separate homes. I understand that some of the functionality (from Metalink threads) seems to have been gone and that there is issues about which version of OEM
Title: RE: Help Urgent Where is Tablespace Manager??
What is the tablespace manager?
When I bring up DBA studio I do not see it
anywhere.
8.1.6 on NT
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Monday
Title: RE: Help Urgent Where is Tablespace Manager??
Paula,
I am
using DBA Studio as a stand-alone product - not using the OMS service part of
the product. I gave up on that because it could not discover all of the
databases at my current site. We tried to figure out why it didn't work
We stopped using it for the same reasons, plus the fact that we had multiple Oracle
Homes on our cluster - which confused OEM.
Where is tablespace manager - just type sqlplus
Jay
[EMAIL PROTECTED] 12/10/02 09:04AM
Paula,
I am using DBA Studio as a stand-alone product - not using the OMS
Title: RE: Help Urgent Where is Tablespace Manager??
We installed OEM on a Linux box ... far away from all production boxes ... works great ... that box only has the OEM installation.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
Title: RE: Help Urgent Where is Tablespace Manager??
OEM
had the tablesapce manager in it. Its called the Storage Manager
now. Maybe that is where the mixup is ?
Run
oemapp by itself. It will tell you which applications are loaded. If
you have loaded it, you should see STORAGE in the list
Title: RE: Help Urgent Where is Tablespace Manager??
Back to my roots.
-Original Message-
From: Jay Hostetter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help Urgent Where is Tablespace Manager??
We
:
[EMAIL PROTECTED] Subject: RE: Help Urgent Where is
Tablespace Manager
Title: RE: Help Urgent Where is Tablespace Manager??
This is driving me crazy. Can't seem to find the tablespace manager which I used to pull up from DBA Studio - now I have a different version which doesn't have DBA Studio - where has it been moved or is there a replacement?
Help
Title: RE: Help Urgent Where is Tablespace Manager??
Okay, Apparently not really supported for 9i database just up to 8.1.7 - what replaces it and why am I having so many problems with JRE files?
-Original Message-
From: Stankus, Paula G
Sent: Monday, December 09, 2002 10:11 AM
Alex - And the funny part is that the person who nailed the solution, Steve
Ollig, also works for us and isn't a part of our official Java initiative.
Do you think he'll ever get good enough to be sent to Java training?
-Original Message-
Sent: Tuesday, December 03, 2002 4:20 PM
To:
John - your problem is that you are reusing the Statement named myStatement
within your while (myTablespaces.next()) loop. just declare and use a
second Statement and i suspect all will be well once again.
from http://java.sun.com/j2se/1.3/docs/api/index.html :
java.sql
Interface Statement
All
Steve,
This was it exactly. Thanks!
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Tuesday, December 03, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
John - your problem is that you are reusing the Statement named myStatement
within
comment out
myDataFiles.close();
and see what happens.
On Tue, 3 Dec 2002, John Weatherman wrote:
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that
John - I forwarded your message to one of our newly-trained Java
programmers. He replied with:
The code is incomplete, how are they handling the connection.
Obviously the while loops are messing each other up.
There are multiple ways of handling this.
If I see the complete code I can
My condolences to you.
On Tue, 3 Dec 2002, DENNIS WILLIAMS wrote:
John - I forwarded your message to one of our newly-trained Java
programmers. He replied with:
The code is incomplete, how are they handling the connection.
Obviously the while loops are messing each other up.
There
Ramon E. Estevez wrote:
Hi list I need some help with a query. I have 3 tables ORIGINALES,
CAMBIOS_ORIGINALES, DATOS_FABRICANTES, I have to be able to query an
article for whatever code the user
provide, ex: (NUMERO_ORIGINAL, CAMBIO_ORIGINAL, NUMERO_FABRICANTE).
The 3 tables
have a
Title: RE: HELP ORACLE TO INFORMIX
Want to quickly move Oracle table to Informix database using Oracle-INformix gateway. Getting
error ORA-02047 when trying to commit every 1000 rows - do we really need to commit after each 1 row
Just check for the Oracle services in Control Panel- Services.
ur Instance,TNS should be started. if not start these services and try
connecting.
Regards,
Sathyanarayanan
|+---
|| john |
|| john_g123_9@|
||
John,
Try this,
$ sqlplus / as sysdba
HTH
...Ponnusamy
At 09:13 AM 11/23/2002 -0800, john wrote:
ver 8i on windows NT4
chose the Typical install in 8i during installation
hence i guess a starter db is created by the installation
via svrmgrl did startup
trying to connect to sqlplus both gui
Shao:
I think your program has become a victim of the new costing model
for bitmap indexes which was introduced in 8.0.6. Basically the
new costing model assumes the 80% of the rows are costed in the
old model and 20% of the rows are costed as they are spread across
ALL blocks.
Let us assume
Any
ideas?
I have
never done this before. It doesn't take any arguments but doesn't like my
execute over the database link and gateway.
u need to set the system operating credentials for the node u are using with
a acount that has at least logon as a batch job directly assigned to it.
Noramally it would administrator/Password
regards
Paulo
-Original Message-
Sent: quarta-feira, 6 de Novembro de 2002 15:04
To: Multiple
A couple of things come to mind...
1. Set credentials for the node ORATEST, usually the user you installed
oracle with on the node.
2. Set credentials for the database to be a user with DBA privileges,
possibly even create a specific user to act as the primary user that you
will do this and other
Sysman is not a user on the database. Set preferered
credentials to someone who has sysdba privs or export full database, import full
database privs.
Ruth
- Original Message -
From:
Arif Khan
(GWL)
To: Multiple recipients of list ORACLE-L
Sent: Wednesday,
If I remember correctly ( a big if) there is an option in the OEM menus to
set the preferred credentials.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:04 PM
Come on folks...Help me, I am
You need to set the credentials for the node. If you are doing an export
on the node, OEM must be able to log into the node. As good practice, you
should create a valid userid and password for each node listed by OEM. OEM
cannot run a job on a node without having a userid to log onto the node
Hi,
We are in a process of purchasing Oracle Database.
This deal will include
hands-on training as well. The course outline given
by the dealer is as
follows:
* Database physical logical Architecture.
* Database Startup and Shutdown.
* Database physical logical backups.
* Operating system
Forgot : enter a technical bookshop and browse (and possibly buy) DBA books. They are
a worthy alternate view.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroul
INET: [EMAIL PROTECTED]
Fat City Network Services--
This is a known oversight...I haven't verified this,
but I've read that you can use the 8.1.6+ one, or the
9.2 one if you've got it handy. In the 8.1 case, the
timings may be a little off due to the change in
precision
hth
connor
--- Grant Allen [EMAIL PROTECTED] wrote: Hi
all,
For some
it's a bug in the install package, they forgot to include tkprof
... you can get a copy of it off Metalink I believe
--- Grant Allen [EMAIL PROTECTED] wrote:
Hi all,
For some reason my 9.0.1 windows install has no tkprof binary, so I'm
trying to decipher some 10046 output. I've got a
Go to the $OH/rdbms/lib directory as the oracle user and run make -f
ins_rdbms.mk itkprof...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 7:39 AM
to table or index
it's a bug in the install package, they forgot to
You can use this query:
-- find_segment.sql
-- Finds segment name based on input file_id and block_id
set Lines 132
col Owner for a10
col Segment_name for a30
col Segment_type for a20
col Tablespace_name for a30
select Owner,
Segment_Name,
Segment_Type,
Tablespace_Name
select * from dba_extents
where file_id = P1
and P2 between block_id and (block_id + (blocks - 1));
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 9:03 PM
table or index
Hi all,
For some reason my 9.0.1 windows install
Title: RE: Win2000/8.1.7.3.0/SQL
Update
... we dont see this problem if we rlogin to
the
server via a Sun Solaris client box.
-Original Message-From: Johnson, Michael
Sent: Friday, October 11, 2002 10:38 AMTo:
'[EMAIL PROTECTED]'Subject: Help on ORA-03113 error and 7445 in
Alex,
If you were performing a long running function such as creating an
index and lost you connection to the database then the index would reach
the end of creation, find that you were not connected and completely
undo the process. The indexes are created in a TEMPORARY segment
before they are
Remember having done something similar some time ago...Check this out and see if this satisfies your requirement
Query :=select type, category, sum(col1) col1, sum(col2) col2, sum(col3) col3, sum(col4) col4from(select type, category, count(*) col1, 0 col2, 0 col3, 0 col4 from agroup by type,
Thank you very much Sunny. It works.
MSN Photos is the easiest way to share and print your photos: Click Here
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erma Fernando
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
SMON is the Oracle background process that handles recovery. Did you
perhaps do a shutdown abort and then restart your database?
If so SMON is rolling forward and rolling back uncommitted transaction.
-Original Message-
Sent: Friday, October 04, 2002 4:44 PM
To: Multiple recipients of
-
De: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Date: mercredi 2 octobre 2002 20:33
À: Multiple recipients of list ORACLE-L
Objet: RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK
That's an Oracle internal table that is created during the database
-
De: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Date: mercredi 2 octobre 2002 20:33
À: Multiple recipients of list ORACLE-L
Objet: RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK
That's an Oracle internal table that is created during the database
Or if you just want to create that view it is in Oracle_home\rdbms\admin\spcusr.sql.
Dave
-Original Message-
Sent: Wednesday, October 02, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
How to create this view X$KSPPI ?
I am trying to install statspack, and it missing this
That's an Oracle internal table that is created during the database creation
time.
What is the exact error you are receiving?
BTW, Do you use APT scripts by Steve Adams?
- Kirti
-Original Message-
Sent: Wednesday, October 02, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
Try this:
select
fk.constraint_name
, pk.table_name pk_table
, pk.constraint_name pk_constraint
, pkc.column_name pk_column
from
dba_constraints fk
, dba_constraints pk
, dba_cons_columns pkc
where fk.owner = 'PRJSTAT'
and fk.table_name = 'PROJECTS'
and fk.r_constraint_name
Title: RE: Help can't restore archive logs from networker through RMAN
Guys, hanging on restoring archive logs only and need for urgent recovery. Oracle suggest doing a trace on allocate channel but can't find syntax for 8.0.6 just 8i which doesn't work.
Help!
What version of the database? What version of forms/reports? What platform? What is
the current
characterset of the database?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Sorry Gurus
The database version is: 8.1.6.0.0
Reports: 6.0.5.28.0
Forms: 6.0.5.2
Current NLS_LANGUAGE: AMERICAN
Current NLS_NCHAR_CHARACTERSET: WE8ISO8859P1
Current NLS_CHARACTERSET: WE8ISO8859P1
Current NLS_CALENDAR: GREGORIAN
Appreciate your response
Shiva
-Original Message-
]
09/25/02 01:13 PMcc:
Please respond toSubject: RE: Help on Effect of
changing NLS_LANGUAGE to
ORACLE-L maerican_america.u
Title: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NADA on METASTINK
Hello
I noticed that your sqlplus logon connects to an idle
instance.
That's mean that you are NOT connected to the
remote database.
You need to set oracle_sid or use connect
system/password@database.
Also
Title: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NADA on METASTINK
I am
actually using shutdown immediate - for testing I used shutdown abort just to
speed up my testing on a database that could take it.
-Original Message-
My guess is that to start up or shut down a database remotely, you have to
use connect user/password as sysdba;
You will probably need a password file.
See Note 1029539.6 on Metalink which describes how to create password file.
HTH,
Gerardo
-Original Message-
Sent: Wednesday,
Title: RE: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NA-ARE YOU SURE?
Nope - Tried all that and didn't work - password file, granting sysdba to sys, changing remote_passwordfile_..=exclusive. It is easier to just run shutdown/startup in rman itself. It it was that easy I
Title: RE: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NA-ARE YOU SURE?
Now I remember why I didn't do this in version 8.0 of database - the startup/shutdown in RMAN that work in 8i+ gave errors. So until we upgrade those to 8i/9 I guess we live with 2 versions of scripts
Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Guys,
User apparently can only execute one stored proc. from a Crystal Reports. There are lots of different types of queries and he would like to cut-down on the number of Crystal Reports he would need. He wishes to create
Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Paula
I don't know
Crystal reports so I'm not sure what you are trying to achieve,
but...
1) If you're
using 8i and can fix the number of bind variables (or don't need to use them at
all) then native dynamic sql (NDS
Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Yes,
it looks like NDS may be able to be used - Reading Johnathon Lewis' Practical 8i
with refcursor. I think this is a better approach then global temporary
table. I will see if there are limitations to this using Crystal
101 - 200 of 485 matches
Mail list logo