10 More Discussions You Might Find Interesting
1. AIX
Hello. I'm a hobbyist who likes to buy old(er) machines on eBay then play around with them (hardware and software). My current project is an IBM RS/6000 43p-150. It came with AIX 5.3 pre-installed, no media or licenses or documentation of any kind. One of the things I like to do is run various... (4 Replies)
Discussion started by: bminear
4 Replies
2. Solaris
My understanding is that Oracle DB licensing is based on number of cores etc. If you use virtual machines (e.g.ldoms) you need to partition it properly otherwise, in theory you have to pay based on the host machine.
Can anyone confirm I'm right here? And explain it in bit more detail (i.e.... (8 Replies)
Discussion started by: psychocandy
8 Replies
3. Red Hat
I wanted to know about licensing for RHEL. We have 3 RHELs as virtual machines using Vmware in our company. A 4th instance is required now but there is talk of not having the 4th license as we have only 3 licenses. Apart from this , I wanted to know how to actually practically enable a license for... (2 Replies)
Discussion started by: RHCE
2 Replies
4. Shell Programming and Scripting
I have a question about the perl license on Solaris machine. The scenario is we have perl 5.6.1 installed on Solaris server. Our developers are planning to use a module which is not installed on the server. We did search CPAN website and found some availability matrix CPAN Testers Matrix:... (3 Replies)
Discussion started by: sudhiroracle
3 Replies
5. SCO
Hello all, I had a few questions about SCO 5.0.7 if anyone has the time.
I have a POS system called RealWorld running on SCO 5.0.7. I have been using the EVAL60ENT code but it has expired and I'm tired of rebuilding/configuring that box from scratch - so I did a little googleing. I found a... (3 Replies)
Discussion started by: disisit69
3 Replies
6. HP-UX
Hello,
We have received a HP Integrity Server rx3600 (itanium architecture) that came with HP-UX on it. The installation of HP-UX is "broken" and it hangs and will not boot. The server did not come with any re installation media. I am just wondering, Legally and within ToS, can I do to restore... (3 Replies)
Discussion started by: 6L71
3 Replies
7. AIX
Hi Guys,
Can someone please give me an introduction with AIX licensing management with 4.x and 5.x?
Is the licensing per user or per cpu or both? How do you push it on the server? Or is it included in the hardware price.
Thanks in advance,
itik (2 Replies)
Discussion started by: itik
2 Replies
8. Solaris
Hi Guys,
Can someone please give me an introduction with Sun licensing?
Is the licensing per user or per cpu or both? How do you push it on the server? Or is it included in the hardware price.
Thanks in advance,
itik (1 Reply)
Discussion started by: itik
1 Replies
9. HP-UX
Hi Guys,
Can someone please give me an introduction with hp-ux licensing?
Is the licensing per user or per cpu or both? How do you push it on the server? Or is it included in the hardware price.
Thanks in advance,
itik (0 Replies)
Discussion started by: itik
0 Replies
10. AIX
On an AIXv5.2 system, that has power5 processors,
I issue the lscfg | grep proc and get
+ proc0
Processor
+ proc2
Processor
+ proc4
Processor
lsattr -El proc0
frequency 1904448000 Processor Speed False
state enable Processor state False
type PowerPC_POWER5... (2 Replies)
Discussion started by: oracledba
2 Replies
SQL::Translator::Parser::Oracle(3pm) User Contributed Perl Documentation SQL::Translator::Parser::Oracle(3pm)
NAME
SQL::Translator::Parser::Oracle - parser for Oracle
SYNOPSIS
use SQL::Translator;
use SQL::Translator::Parser::Oracle;
my $translator = SQL::Translator->new;
$translator->parser("SQL::Translator::Parser::Oracle");
DESCRIPTION
From http://www.ss64.com/ora/table_c.html:
CREATE [GLOBAL TEMPORARY] TABLE [schema.]table (tbl_defs,...)
[ON COMMIT {DELETE|PRESERVE} ROWS]
[storage_options | CLUSTER cluster_name (col1, col2,... )
| ORGANIZATION {HEAP [storage_options]
| INDEX idx_organized_tbl_clause}]
[LOB_storage_clause][varray_clause][nested_storage_clause]
partitioning_options
[[NO]CACHE] [[NO]MONITORING] [PARALLEL parallel_clause]
[ENABLE enable_clause | DISABLE disable_clause]
[AS subquery]
tbl_defs:
column datatype [DEFAULT expr] [column_constraint(s)]
table_ref_constraint
storage_options:
PCTFREE int
PCTUSED int
INITTRANS int
MAXTRANS int
STORAGE storage_clause
TABLESPACE tablespace
[LOGGING|NOLOGGING]
idx_organized_tbl_clause:
storage_option(s) [PCTTHRESHOLD int]
[COMPRESS int|NOCOMPRESS]
[ [INCLUDING column_name] OVERFLOW [storage_option(s)] ]
nested_storage_clause:
NESTED TABLE nested_item STORE AS storage_table
[RETURN AS {LOCATOR|VALUE} ]
partitioning_options:
Partition_clause {ENABLE|DISABLE} ROW MOVEMENT
Column Constraints (http://www.ss64.com/ora/clause_constraint_col.html)
CONSTRAINT constrnt_name {UNIQUE|PRIMARY KEY} constrnt_state
CONSTRAINT constrnt_name CHECK(condition) constrnt_state
CONSTRAINT constrnt_name [NOT] NULL constrnt_state
CONSTRAINT constrnt_name REFERENCES [schema.]table[(column)]
[ON DELETE {CASCADE|SET NULL}] constrnt_state
constrnt_state
[[NOT] DEFERRABLE] [INITIALLY {IMMEDIATE|DEFERRED}]
[RELY | NORELY] [USING INDEX using_index_clause]
[ENABLE|DISABLE] [VALIDATE|NOVALIDATE]
[EXCEPTIONS INTO [schema.]table]
Note that probably not all of the above syntax is supported, but the grammar was altered to better handle the syntax created by
DDL::Oracle.
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
SEE ALSO
SQL::Translator, Parse::RecDescent, DDL::Oracle.
perl v5.14.2 2012-01-18 SQL::Translator::Parser::Oracle(3pm)
