06-23-2011
How's the permissions on tnsnames.ora ?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I wanted to add /home/oracle/sql to my path so that from which ever directory i connect to sqlplus i should be able to source the .sql files sitting in /home/oracle/sql. Also,
this is what i tried but it doenst work
# Set up the search paths:
export ... (2 Replies)
Discussion started by: jigarlakhani
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
i am changing something in .profile file and then esc :wq!. when i do the cat i can see the changes. but to bring the .profile in memory i have to do . .profile.but it says error while doing that is . .profile
ksh: .profile: not found.
can any body help
thanks in advance
sam71 (7 Replies)
Discussion started by: sam71
7 Replies
3. UNIX for Dummies Questions & Answers
The “set -o vi” command won't run in the .profile. WHY?
This has me puzzled as the problem seems to be too simple, but can't figure it out. Here's the info...
Running...
Generic sun4u sparc SUNW,Ultra-5_10
K shell
Here's the .profile
# Copyright (c) 2001 by Sun Microsystems, Inc.
# All... (12 Replies)
Discussion started by: jimmyc
12 Replies
4. Shell Programming and Scripting
I am trying to execute my .profile which has the path to oracle home. But when I execute it with the below command it says nothing and when I try to echo the ORACLE_HOME I am still in my home directory itself which means it didn't get executed.
Please help how to make sure that .profile is... (6 Replies)
Discussion started by: dsravan
6 Replies
5. Solaris
for some reason my profile doesnt seem to be loading.
here is some info
$SHELL /sbin/sh
$HOME / (yup, im running at root, its a VM and im using it to learn)
created /.profile
added something simple to test, PS1="test"
logout and back in, open a terminal... prompt is still #
... (2 Replies)
Discussion started by: jrich523
2 Replies
6. Shell Programming and Scripting
Hi All,
I have trying to schedule an autosys job and it is failing. The shutdown script runs fine by itself from the UNIX box but fails when i try to schedule it through autosys.
I have compared user.env with auto.env (variables obtained through an autosys script) and updated my profile... (1 Reply)
Discussion started by: userscript
1 Replies
7. Shell Programming and Scripting
How can we hardcode TNS_ADMIN?
When i try to connect to db with the code below..i get TNS issue. So wpndering if i can hardcode TNS..
<html>
<head>
<title>xxxxxxxxxxxxxx</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%
### Load modules, connect to... (2 Replies)
Discussion started by: rdhanek
2 Replies
8. Shell Programming and Scripting
I am new in shell scripting. currently i am using cygwin. My problem is
i created a profile file in my own folder. file name is first.profile in which i gave following values to variable
export a=10
now i am executing this profile file by below command
./.first.profile
it executed... (4 Replies)
Discussion started by: pratikjain998
4 Replies
9. UNIX for Dummies Questions & Answers
I am using MacOSX, and I decided to change the way my terminal looks. So, I created a ~/.profile file that has only the line
export PS1="\\u\ @ \\W \($0) \\$ \" ( '\u' displays the current user
'\W' displays the Working dir
and the weird numbers are colors)
It works fine when I log in... (3 Replies)
Discussion started by: TX0
3 Replies
10. UNIX for Beginners Questions & Answers
i have a bash_profile
in this profile there are my variable but when i do csh there aren't my variables .set
how can i do ?
regards
Franc (1 Reply)
Discussion started by: Francesco_IT
1 Replies
LEARN ABOUT DEBIAN
sql::translator::parser::oracle
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)