Toad for Oracle 11G - schema browser not working

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Toad for Oracle 11G - schema browser not working
# 1  
Old 05-12-2011
Error 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
Login or Register to Ask a Question

Previous Thread | Next Thread

3 More Discussions You Might Find Interesting

1. Programming

converting data from excel sheet to oracle using toad

guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies

2. 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 Replies)
Discussion started by: girija
5 Replies

3. Programming

Toad oracle with Unix

Hi Experts, Iam a C/C++ developer but want to learn Proc with oracle and how to connect with TOAD and what RAC please help me explain me with respect to Unix operating system only installations of these with respect to the Unix operating system. plese help me to understand these topics. ... (1 Reply)
Discussion started by: vin_pll
1 Replies
Login or Register to Ask a Question
SQL::Translator::Schema(3pm)				User Contributed Perl Documentation			      SQL::Translator::Schema(3pm)

NAME
SQL::Translator::Schema - SQL::Translator schema object SYNOPSIS
use SQL::Translator::Schema; my $schema = SQL::Translator::Schema->new( name => 'Foo', database => 'MySQL', ); my $table = $schema->add_table( name => 'foo' ); my $view = $schema->add_view( name => 'bar', sql => '...' ); DESCSIPTION
"SQL::Translator::Schema" is the object that accepts, validates, and returns the database structure. METHODS
as_graph_pm Returns a Graph::Directed object with the table names for nodes. add_table Add a table object. Returns the new SQL::Translator::Schema::Table object. The "name" parameter is required. If you try to create a table with the same name as an existing table, you will get an error and the table will not be created. my $t1 = $schema->add_table( name => 'foo' ) or die $schema->error; my $t2 = SQL::Translator::Schema::Table->new( name => 'bar' ); $t2 = $schema->add_table( $table_bar ) or die $schema->error; drop_table Remove a table from the schema. Returns the table object if the table was found and removed, an error otherwise. The single parameter can be either a table name or an "SQL::Translator::Schema::Table" object. The "cascade" parameter can be set to 1 to also drop all triggers on the table, default is 0. $schema->drop_table('mytable'); $schema->drop_table('mytable', cascade => 1); add_procedure Add a procedure object. Returns the new SQL::Translator::Schema::Procedure object. The "name" parameter is required. If you try to create a procedure with the same name as an existing procedure, you will get an error and the procedure will not be created. my $p1 = $schema->add_procedure( name => 'foo' ); my $p2 = SQL::Translator::Schema::Procedure->new( name => 'bar' ); $p2 = $schema->add_procedure( $procedure_bar ) or die $schema->error; drop_procedure Remove a procedure from the schema. Returns the procedure object if the procedure was found and removed, an error otherwise. The single parameter can be either a procedure name or an "SQL::Translator::Schema::Procedure" object. $schema->drop_procedure('myprocedure'); add_trigger Add a trigger object. Returns the new SQL::Translator::Schema::Trigger object. The "name" parameter is required. If you try to create a trigger with the same name as an existing trigger, you will get an error and the trigger will not be created. my $t1 = $schema->add_trigger( name => 'foo' ); my $t2 = SQL::Translator::Schema::Trigger->new( name => 'bar' ); $t2 = $schema->add_trigger( $trigger_bar ) or die $schema->error; drop_trigger Remove a trigger from the schema. Returns the trigger object if the trigger was found and removed, an error otherwise. The single parameter can be either a trigger name or an "SQL::Translator::Schema::Trigger" object. $schema->drop_trigger('mytrigger'); add_view Add a view object. Returns the new SQL::Translator::Schema::View object. The "name" parameter is required. If you try to create a view with the same name as an existing view, you will get an error and the view will not be created. my $v1 = $schema->add_view( name => 'foo' ); my $v2 = SQL::Translator::Schema::View->new( name => 'bar' ); $v2 = $schema->add_view( $view_bar ) or die $schema->error; drop_view Remove a view from the schema. Returns the view object if the view was found and removed, an error otherwise. The single parameter can be either a view name or an "SQL::Translator::Schema::View" object. $schema->drop_view('myview'); database Get or set the schema's database. (optional) my $database = $schema->database('PostgreSQL'); is_valid Returns true if all the tables and views are valid. my $ok = $schema->is_valid or die $schema->error; get_procedure Returns a procedure by the name provided. my $procedure = $schema->get_procedure('foo'); get_procedures Returns all the procedures as an array or array reference. my @procedures = $schema->get_procedures; get_table Returns a table by the name provided. my $table = $schema->get_table('foo'); get_tables Returns all the tables as an array or array reference. my @tables = $schema->get_tables; get_trigger Returns a trigger by the name provided. my $trigger = $schema->get_trigger('foo'); get_triggers Returns all the triggers as an array or array reference. my @triggers = $schema->get_triggers; get_view Returns a view by the name provided. my $view = $schema->get_view('foo'); get_views Returns all the views as an array or array reference. my @views = $schema->get_views; make_natural_joins Creates foriegn key relationships among like-named fields in different tables. Accepts the following arguments: o join_pk_only A True or False argument which determins whether or not to perform the joins from primary keys to fields of the same name in other tables o skip_fields A list of fields to skip in the joins $schema->make_natural_joins( join_pk_only => 1, skip_fields => 'name,department_id', ); name Get or set the schema's name. (optional) my $schema_name = $schema->name('Foo Database'); translator Get the SQL::Translator instance that instantiated the parser. AUTHOR
Ken Youens-Clark <kclark@cpan.org>. perl v5.14.2 2012-01-20 SQL::Translator::Schema(3pm)