|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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. 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 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 : You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P. ... Read Answers (3) | Asked by : ram Latest Answer : DUAL is a table.That is owned by SYS user .It has a column name as dummy and it containts a row having a vale "X".The dual table is useful when u want to retun a value once only,the value that is not derived in from a table with ... My table has duplicate values pls help me How can i delete those values For Ex: my table contains 200 rows in that 100 rows are duplicate values and i can i delete those 100 rows pls give me answerregardsmangaiah Latest Answer : Dear friend : oracle generate sequence numbers with the help of predefined function called nextval.so if you want insert these generated sequence no you can do using .nextvalfor eg:let us say we have the following table:sample:x ... Read Answers (2) | Asked by : smitesh shinde Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks Read Answers (2) | Asked by : vishnu Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under M2. Suppose S1 (whose manager is M1) creates 2 records. S2 will be able to see them ?.Now, if i change the parent position of S1 (i.e., if now, S1 is placed under M2 instead of M1), and responsibility remaining the same as earlier (Sales rep resp), will the Manager M1 be still able to see the records created by S1 ? Please clarify this. Thanks View Question | Asked by : s View Question | Asked by : Vikram
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
