Is there anyone can tell me whats wrong with my database. I dont know what is actually the problem is in my oracle scott database i got some garbage table name once i try to execute "select table_name from user_tables" command. Here is the output of that sql query.
SQL> select table_name from us
41 rows selected.
what is those bin bla bla i got no idea.
Im useing oracle10g home my OS is winxp and my paths are
C:\Documents and Settings\Hasnain>path
ql\bin;C:\Program Files\Rational\common;C:\Program Files\Rational\ClearQuest;C:\
Program Files\Rational\Rose\TopLink\;C:\Program Files\Rational\Rational Test;c:\
matlab6p5\bin\win32;C:\MATLAB6p5\bin\win32;c\php;C:\Program Files\SSH Communicat
ions Security\SSH Secure Shell
Please help me i dont know whats wrong with it.
How do you define an "unnecessary bin"?
When you are dropping a table, you can specify the PURGE clause to bypass the recycle bin. You can also purge objects from the recycle bin
Oracle also maintains a mapping of the recycle bin name to the original table name in USER_ or DBA_RECYCLEBIN
Distributed Database Consulting, Inc.
Hi All, i want to restore deleted records of a particular table in other table suppose: i perform a query delete from emp where deptno =30; now i wont to restore deptno=30 records in other table, let say in emp1 table can any one let me know how to d
Hi, how to import/convert MySQL database/tables into oracle database/table. i need SQL code or any import wizard technique. ThnxzPlease refer: http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.htmlRead other 2 answers
Hi, I am doing a program regarding analysis of tables belonging to archiving objects.In my program i am calling a RFC function module . 'DB02_ORA_TABLE_INDEX_ANALYSIS . But it is giving the dump for native sql statement . --- Oracle block size ------
Hi, Im new bi to oracle database..., Will anyone provide me the command to list the user tables in oracle 9i database.??. im using linux redhat 4.0... and oracle 9i database.... thanks, vasanth....user12864080 wrote: Hi, Im new bi to oracle database.
Hi, Can anyone let me know the internal behaviour of Truncate Table Command in Oracle Database? Thanks, Harshad.Hi Tuhinshoor, I know the functioning of Truncate Command. But, I needed to know whether it drops the table before recreating it, maintain
Hi Everyone, My Jdev version is 22.214.171.124.0. I have developed many ADF applications in this version itself by setting time zone as -Duser.timezone="+05:30" and all were running fine. But Jdeveloper got crashed so i reinstalled the same version bu
Hi I want donwload Oracle Database all table structure , any one please explain where i can download the structure in text format regardsSQL> desc user_tables; Name Null? Type TABLE_NAME NOT NULL VARCHAR2(30) TABLESPACE_NAME VARCHAR2(30) CLUSTER_NAME
I'm trying to setup GTC connector to provisioning/reconcile users into database tables, but during the provisionig gtc fails. check the lines above to see the error ERROR,07 Nov 2010 20:18:38,383,[OIMCP.DATC],Class/Method: DBProvisioningTransportProv
Hi! Assuming I created a dblink between an Oracle EBS database and another oracle database and I wish to create custom dashboards and reports in Oracle Daily Business Intelligence, will the tables/views from the another oracle database be allowed as
Hi, im creating a form that will upload a text file(TAB delimited) that will insert a data in a database table. How would i do this? And what trigger will i use in the upload button? Please help.. Thanks, Majichi majic, Check any of this site related
Hi. We got our Oracle database admin to install APEX in our Oracle database. She created a login and schema for my Oracle database user so that I could work with APEX a little. Here's the information on the version of APEX we have installed: Database
When creating an Answers report that queries from a table owned by a custom schema (not APPS), I cannot query the table and get error. Once I add a Synonym for APPS on this table, then OBIEE works normally. Since OBIEE is logging in as the APPS user,
Our Problem: Oracle connector is unable to retrieve the schema for column selection (uninstrumented/instrumented columns) in the connector setup due to timeout on a database with a large amount of schema. Has anyone else had a similar experience? We
Hello everybody, i have more than 600 tables in the database i need to find the biggest table in the database and want to order it in descending pattern.. Is there any query for this task... Rgds Harsh.What version of Oracle? Do you use the CBO or th
Hi All, I am selecting a CLOB field from Oracle database table using JDBC Sender adapter and getting error "NullPointerException" Seen SAP note 1283089 but its not applicable for my support pack PI 7.0 SP 12 and client dont want to upgrdate SP 1
Hi, We have a requirement to develop an XI interface from FTP server(File adapter) to oracle database using JDBC adapter. In the oracle database table few fields are of type NCHAR/NVARCHAR. when we try to insert the character(A,B,c..) values into ora
I created a form with oracle as my database. But there one trigger where I need to insert the data into a sql server table. Is this possible. If so can any help me out. Thanks in advance. AshaHi, You can insert into sql server database using the foll
The problem is this: I have a application (SKF @ptitude Analyst), uses oracle database in version 9i, 10g, 11g. My recomendations for working persons with the software, is that often make a backup the database (for this use the command"exp"). bu
We are working at a project with the follow architecture: - 5 Databases (3 Oracle, 1 Sybase and 1 DB2); - Session Bean like Session Facade Pattern; - Entity Bean (BMP); - OC4J (Oracle Container for J2EE); The case is that we cannot make join between