 Related Questions I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible. 8060 Latest Answer : Hi,Rowsize depends up on the no of columns and their size , you can calculate the avg row size using vsize and maximum we can have 1000 col in table. ... Read Answers (1) | Asked by : Sabby Latest Answer : oracle supports two types of joins: 1.oracle joins cartesian join equi join non equi join self join outer join is exhibited using "+" operator 2.ansii ... Latest Answer : Select * from dba_objects where owner = 'GL' and object_type = 'TABLE'Change GL to AP and AR for respective table info. ... Read Answers (1) | Asked by : mahendra Latest Answer : For time being type below command at sql promptSQL>define_editor=viYou can add export EDITOR=vi in .profile and logou/login for permament changeHope this will solve it ... I am creating one table in oracle. in database it is allocated some memory for that table. how can i know how much memory that table is holding in that database? Latest Answer : IN->Equal to Any One in the List.ANY->Compares Value to Each Value Returned by the Sub Query.ALL->Compares Value To Every Value Returned by the Sub Query.For Example:IN:(Q):Display the Details of all the Employees Whose Salaries are ... Latest Answer : Dual is a system defined table having one rows and one column. A person who has informed that it has virtual
existence is not proper. It has physical existence.Ex:SQL> select * from dual;D-XMeans a table having single row and columns.Regards,Deepak ... Can a Revoke or alter user statement be executed on a Session to modify a user's role (set as default) or revoke a role based on whether the uesr logged into a defined list of valid applications versus SQL Plus? I want to set one role if the user connects via an appropriate app and set a readonly type role if the user connects with something else. This is needed to resolve an audit issue. View Question | Asked by : T Landon Latest Answer : Ends the current transaction by making all pending data changes permanent.Is the simplest way to define.Transaction means start with an DML SQL Statement and end with one of the following 1) A commit or rollback statement is issued, or2) DML OR DCL ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
