1) select * from v$database;
Note: Picky perhaps, but instance and database may be different.
...
3) grant create session to scott;
Note: CONNECT is a role that includes the create session system privilege
and a LOT more. It is NOT a synonym for create session.
...
Don Granaman
OraSaurus
-
I would strongly recommend a good beginner DBA text
such as DBA 101.
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1044859784
This will give you a good foundation for reading the docs.
Jared
On Saturday 08 February 2003 18:28, majid wrote:
Hi,
I used to use mysql databse, now
Majid:
1) Try select name from v$database;
2) Use the connect keyword to connect to another database. Example :
connect userid@database_name.
3) To create users, try
create user [username] identified by [password] default
tablespace [tablespace_name]
temporary tablespace
1)How to find out from sqlplus what is the current
database ?
once, connected, do select * from v$instance;
2)and how to switch to another one ?
from DOS prompt: by chaning your ORACLE_SID environment variable
or via Net8: either from SQL*Plus: connect system/manager@another_db
or from DOS:
thanks a lot 4 your replies.
/*i followed the way dick and mark suggested.*/
daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Wisser
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Daniel - Can you explain the two alternatives in a little more detail,
especially the difference between the two. What types of systems are
involved (Unix, Windows)? Thanks.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003
hi!
a DBA inteds to speed up a script that is looping
and
sending hundred thousands of sequential update
statements like:
UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n;
he suggests copying the table to a file, change it
and then
load it into the DB again. i am strongly convinced
that this
is
Daniel,
Your gut reaction is right on-target. It is always a struggle to keep
certain folks from killing the entire village while trying to cure a single
case of the sniffles. What's worse is that such folks are usually quite
bright and talented. After, very few mediocre folks can either cure
Even with this little bit of information, it's obvious your DBA
is on the right track.
Any script that loops and executes 'hundred thousands of
sequential update statements' is total nonsense.
This will bring most any database to it's knees in a hurry.
Oh yes, I've had developers pull this
Yep, I've done it before without any problems
-Original Message-
Sent: 17 May 2001 05:06
To: Multiple recipients of list ORACLE-L
Thank you so much for the info, DC.
I have another stupid question. Can I have two different ports for two
database in the same tnsname.ora on the same
Hi,
Yes, you can modify instance parameters in the initXYZ.ora file.
After you change them, they take effect when you bounce the instance
(shutdown and startup)
Also, there are some parameters that can be modify on the fly, without
bouncing the instance.
check this.
SQL desc
Thank you so much for the info, DC.
I have another stupid question. Can I have two different ports for two
database in the same tnsname.ora on the same server?
Cheers,
Julia
-Original Message-
Sent: Wednesday, May 16, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
Hi,
Hi Rakesh,
The Oracle user you are logged in as does not have select permission on
V$SESSION. Log in as sys and issue the command:
grant select on SYS.V_$SESSION to oracle user name;
HTH,
-Rocky
--- Rakesh Dinger [EMAIL PROTECTED] wrote:
Hi, I a newbie in Oracle and am trying to create a
Did you create the package spec before you created the body?
Kev
-Original Message-
Dinger
Sent: Thursday, March 01, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L
Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL,
so please bear with me.
The statements
Let the beatings begin! grin
The package will compile, but the error is basically a security issue. For
some stupid reason, Oracle requires that access to objects referenced within
packages and procedures (and views, too, methinks) be done explicitly to the
owner of the package, and not to a
yup :)
From: "Mohan, Ross" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Newbie question on Packages
Date: Thu, 01 Mar 2001 12:40:41 -0800
Beat me with an overextended RBS if
you need be, but other than any
, Sussex, WI USA
-Original Message-
From: Jesse, Rich
Sent: Thursday, March 01, 2001 15:46
To: Multiple recipients of list ORACLE-L
Subject: RE: Newbie question on Packages
Let the beatings begin! grin
The package will compile, but the error is basically a
security issue
17 matches
Mail list logo
