8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All,
I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump.
Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies
2. Shell Programming and Scripting
In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one.
But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies
3. Cybersecurity
Hi guys,
we are implementing new ldap in our organization exclusively for Linux authentication purposes. As we are new to the subject, I would appreciate help regarding which schema to use to create group of users and accounts / passwords entries? I see both schemas listed in subject above... (0 Replies)
Discussion started by: Lastminute
0 Replies
4. Emergency UNIX and Linux Support
Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue..
I need it asap thats y posted here
Thanks (5 Replies)
Discussion started by: girija
5 Replies
5. UNIX and Linux Applications
Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue (0 Replies)
Discussion started by: girija
0 Replies
6. Shell Programming and Scripting
Hi,
I need my script to accept a column name and give all the tables and its schema.
Any kind of help is appreciated...
Thanks in advance... (2 Replies)
Discussion started by: bankimmehta
2 Replies
7. UNIX for Dummies Questions & Answers
hi guys,
Unix dummy here.
I need help creating a script for class.
The assignment reads as follows:
create a script that will create a new schema in schema.txt, it must accept 7 arguments (the first being the name of the schema) the other 6 being the 6 field names. the schema has to be tested... (1 Reply)
Discussion started by: zodester
1 Replies
8. Shell Programming and Scripting
I have a script which gives the output of schemas in Oracle DB :
#!/bin/ksh
ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL
do
if ; then
ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:.
... (0 Replies)
Discussion started by: run_time_error
0 Replies
Alzabo::Schema(3pm) User Contributed Perl Documentation Alzabo::Schema(3pm)
NAME
Alzabo::Schema - Schema objects
SYNOPSIS
use base qw(Alzabo::Schema);
DESCRIPTION
This is the base class for schema objects..
METHODS
name
Returns a string containing the name of the schema.
table ($name)
Returns an "Alzabo::Table" object representing the specified table.
An "Alzabo::Exception::Params" exception is throws if the schema does not contain the table.
tables (@optional_list)
If no arguments are given, this method returns a list of all "Alzabo::Table" objects in the schema, or in a scalar context the number of
such tables. If one or more arguments are given, returns a list of table objects with those names, in the same order given (or the number
of such tables in a scalar context, but this isn't terribly useful).
An "Alzabo::Exception::Params" exception is throws if the schema does not contain one or more of the specified tables.
has_table ($name)
Returns a boolean value indicating whether the table exists in the schema.
begin_work
Starts a transaction. Calls to this function may be nested and it will be handled properly.
rollback
Rollback a transaction.
commit
Finishes a transaction with a commit. If you make multiple calls to "begin_work()", make sure to call this method the same number of
times.
run_in_transaction ( sub { code... } )
This method takes a subroutine reference and wraps it in a transaction.
It will preserve the context of the caller and returns whatever the wrapped code would have returned.
driver
Returns the "Alzabo::Driver" object for the schema.
rules
Returns the "Alzabo::RDBMSRules" object for the schema.
sqlmaker
Returns the "Alzabo::SQLMaker" object for the schema.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Schema(3pm)
Copy records from one schema to another schema in ORACLE