7 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. 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
6. 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
7. 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
Bio::Chado::Schema::Test(3pm) User Contributed Perl Documentation Bio::Chado::Schema::Test(3pm)
NAME
Bio::Chado::Schema::Test - Library to be used by Bio::Chado::Schema test scripts.
SYNOPSIS
use lib qw(t/lib);
use Bio::Chado::Schema::Test;
use Test::More;
my $schema = Bio::Chado::Schema::Test->init_schema();
DESCRIPTION
This module provides the basic utilities to write tests against Bio::Chado::Schema.
METHODS
init_schema
my $schema = Bio::Chado::Schema::Test->init_schema(
deploy => 1,
populate => 1,
storage_type => '::DBI::Replicated',
storage_type_args => {
balancer_type=>'DBIx::Class::Storage::DBI::Replicated::Balancer::Random'
},
);
This method removes the test SQLite database in t/var/BCS.db and then creates a new, empty database.
This method will call deploy_schema() by default, unless the deploy flag is set to 0.
This method will call populate_schema() if the populate argument is set to a true value.
has_custom_dsn
Returns true if the BCS_TEST_DSN environment variable is set.
deploy_schema
Bio::Chado::Schema::Test->deploy_schema( $schema );
This method does one of two things to the schema. It can either call the experimental $schema->deploy() if the BCSTEST_SQLT_DEPLOY
environment variable is set, otherwise the default is to read in the t/lib/sqlite.sql file and execute the SQL within. Either way you end
up with a fresh set of tables for testing.
populate_schema
Bio::Chado::Schema::Test->populate_schema( $schema );
After you deploy your schema you can use this method to populate the tables with test data.
perl v5.14.2 2011-11-08 Bio::Chado::Schema::Test(3pm)
