creating a schema

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

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?

2. Shell Programming and Scripting

Parallel export of all oracle DB schema.

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...

3. Cybersecurity

LDAP rfc2307bis.schema or nis.schema?

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...

4. Emergency UNIX and Linux Support

Toad for Oracle 11G Schema browser

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. UNIX and Linux Applications

Toad for Oracle 11G - schema browser not working

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

6. Shell Programming and Scripting

find a column in a schema

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...

7. Shell Programming and Scripting

Script for checking schema satistics in Oracle

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:. ...

LEARN ABOUT DEBIAN

dbicx::testdatabase::subclass

DBICx::TestDatabase::Subclass(3pm)			User Contributed Perl Documentation			DBICx::TestDatabase::Subclass(3pm)

NAME

       DBICx::TestDatabase::Subclass - a DBICx::TestDatabase you can add your own methods to

SYNOPSIS

       Your test database subclass:

	  package MyApp::TestDatabase
	  use base qw(DBICx::TestDatabase::Subclass MyApp::Schema);

	  sub foo {
	     my $self = shift;
	     return $self->resultset('Foo')->create({ foo => 'bar' });
	  }

       Later:

	  use MyApp::TestDatabase;
	  my $schema = MyApp::TestDatabase->connect;
	  my $foo_row = $schema->foo; # MyApp::TestDatabase::foo
	  my $bars = $schema->resultset('Bar'); # MyApp::Schema::resultset

DESCRIPTION

       Sometimes DBICx::TestDatabase doesn't give you enough control over the object returned.	This module lets you create a custom test database
       class.

METHODS

   connect
       This method creates the temporary database and returns the connection.  If your subclass needs to change the way connect works, do
       something like this:

	   sub connect {
	       my ($class) = @_;

	       say 'This happens before we create the test database.';
	       my $schema = $class->next::method;
	       say '$schema is the temporary test database';

	       return $schema;
	   }

SEE ALSO

       If you want a simple test database based on a DBIC schema, just use DBICx::TestDatabase.

AUTHOR

       Jonathan Rockway "<jrockway@cpan.org>"

LICENSE

       Copyright (c) 2007 Jonathan Rockway.

       This program is free software.  You may use, modify, and redistribute it under the same terms as Perl itself.

perl v5.10.1							    2007-10-07					DBICx::TestDatabase::Subclass(3pm)

UNIX for Dummies Questions & Answers