On Fri, 09 Jun 2006 16:08:53 +1000, Ron Savage wrote:
Hi Ron
OK. I got this working.
I created a user thru the Oracle web interface http://127.0.0.1:8080/apex.
This allows setting:
o Username
o Password & its expiry (Y/N)
o Account status (Locked/Unlocked)
o User privileges
These are fixed:
o D
Comments below ...
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 08, 2006 10:47 PM
To: List - DBI users
Subject: Oracle schema names: sqlplus 'v' Perl
This is Oracle V 10.02.0010 for Windo
On Fri, 9 Jun 2006 15:13:04 -0400, Jeffrey Seger wrote:
Hi Jeffrey et al
>> Just for the sake of completeness, are you logging in as 'SYSTEM'
>> in your perl script?
>> Or are you logging in as a user which might not have permission
>> to see the table?
I'm logging in as 'system' to create all t
Just for the sake of completeness, are you logging in as 'SYSTEM' in
your perl script?
Or are you logging in as a user which might not have permission to
see the table?
-Chris
In his original post, he did show that he was logged in, at least on
sqlplus, as system. I assumed he was in DBD::Ora
I
On Jun 9, 2006, at 2:08 AM, Ron Savage wrote:
On Fri, 9 Jun 2006 01:17:06 -0400, Jeffrey Seger wrote:
So a similar query to what you are looking for in table_info is:
select table_name, owner from all_tables where table_name like
'%STATE%';
Hmmm.
SQL> select table_name, owner from all_tab
On Fri, 9 Jun 2006 01:17:06 -0400, Jeffrey Seger wrote:
Hi Jeffrey
> So a similar query to what you are looking for in table_info is:
> select table_name, owner from all_tables where table_name like
> '%STATE%';
Hmmm.
SQL> select table_name, owner from all_tables where table_name like '%STATE%'
Is TABLESPACE_NAME the same as schema?
No, table_space refers to the set of physical files (one or several
files) that a particular table is stored in. One table space may
house several schemas (such as USERS) and/or one schema may span
several tablespaces, though each schema has a default t
This is Oracle V 10.02.0010 for Windows.
Under sqlplus I can log in as system/seekrit, and can do:
SQL> select table_name, tablespace_name from user_tables where table_name like
'%STATE%';
TABLE_NAME TABLESPACE_NAME
-- -
