Sitemap

Amicuk Programming Answers

Problem in create query

2015-10-11   Views:0

Advertisement

Hai good afternoon to all, When i execute create query in oracle9i{create table t1 as(select * from t6)} it shown error like that ERROR at line 1: ORA-01536: space quota exceeded for tablespace 'SYSTEM' Please tell me the solution..Hi You are using t

Hai good afternoon to all,
When i execute create query in oracle9i{create table t1 as(select * from t6)}
it shown error like that
ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'SYSTEM'
Please tell me the solution..

The replay answer
Advertisement
Hi
You are using the SYSTEM tablespace as your default tablespace
Tell your DBA to use some other tablespace
Using SYSTEM tablespace as default tablespace is a bad idea

Go to See the other 8 answers

Problem in create query

Category:DefaultRelease time:2015-10-11Views:130

Hai good afternoon to all, When i execute create query in oracle9i{create table t1 as(select * from t6)} it shown error like that ERROR at line 1: ORA-01536: space quota exceeded for tablespace 'SYSTEM' Please tell me the solution..Hi You are using t[More]

Problem in creating query - no data selected

Category:DefaultRelease time:-0001-11-30Views:130

Dear Expert, I have created infoset with the following table join: -AFKO -AFPO -BSIS -BKPF When generate the infoset, this warning message displayed: "Unit field MARA-MEINS will not be filled Affected quantity fields:                    AFKO-GASMG   [More]

Problem with create universe on Business Objects XI 3.1 base on SAP Query

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have a problem with create universe on Business Objects XI 3.1 base on SAP Query. The problem is hierarchy. Massage on Busines Objects is :    OWBS_ELEMT__ISTKOSZT(cube ICPC01/BEX_ICOC01):Exception condition  "HIERARCHY NOT FOUND" raise[More]

Problem of creating workbook with permanent template?

Category:DefaultRelease time:2015-10-11Views:130

Hi all, Iam facing some problem while creating the workbook with permanent template.Let me expalin in detail. I have created 3 queries (ex:Stock) and i have to insert these in one workbook with permanent template.I  had selected the the permanent tem[More]

Problems in SQL Query

Category:DefaultRelease time:2015-10-11Views:130

Dear All, I am having some problem in SQL query. I am trying to get total sum of one inventory using the following query it works fine: sum(case when mt.transaction_quantity > 0 then (mt.transaction_quantity) else 0 end) "TOT_IN" ,sum(case wh[More]

Strange problem in a query

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I'm facing a non-sense problem in a query, I hope you could help me. I have defined a structure in the rows of my query. Inside the structure, I have defined several selections and formulas. Selections are basically account intervals and f[More]

Problem with rowset query

Category:DefaultRelease time:-0001-11-30Views:130

hi, i work whith oracle 8.1.7 . when i define this query SELECT ALL CREATOR.ARTICLE.SOC_CODE, LIBELLE.ACT_LIB(ARTICLE.ACT_CODE) BR_ACT_LIB, LIBELLESYSTBLN_LIB('LGN_CODE',ARTICLE.LGN_CODE) LNG_LIB, substr(LIBELLE.MRQ_LIB(ARTICLE.MRQ_CODE),1,35) MRQ_LI[More]

Problem with af:query

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a problem with af:query. Here's what I do: 1. create a VO, define view criteria 2. drag and drop view criteria from data controls to an empty form, choosing query and table 3. When I run the page and click any of the buttons, I get: "Becau[More]

Problem when create auto numbering in BP master using Formatted Search

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I have a problem in creating auto numbering in BP for Customer type using Formatted search My query is like this declare @tempNo as char(20) set @tempNo=(select  Isnull(max(REPLACE(OCRD.CardCode , LEFT(OCRD.CardCode,10),'')),0)  + 1 from OCRD[More]

Problem in creating workbook

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have a problem in creating workbook. After inserting the query and saving as workbook, when the workbook is opened again there is no query inserted into it. Some values looks like alpha numeric values are populating. I'm using BEx 3.5 and M[More]

Problem use SQL query in coding report with SBO

Category:DefaultRelease time:-0001-11-30Views:130

Hi everyone! I have problem in execute query to delete and create a report with SQL 2000 in SAP. Try         oForm.DataSources.DataTables.Item(0).ExecuteQuery("DELETE FROM rptReport") Catch ex As Exception End Try          oForm.DataSources.Data[More]

Hot
My "old" laptop (Mac) will not support the new firefox version and I want to reinstall the older one, but can't find it on your website.You can get Firefox 3.6 from http://www.mozilla.com/en-US/firefox/all-older.htmlRead other 2 answers [More]
All of our Macs are connected to dual 20" viewsonic flat panels. I relocated one yesterday, leaving the original flat panels and hooking the Mac up to another set of dual fps (same model). I had no problem with the display coming back up and recogniz [More]
Hi, Where i can have a look to oracle table structure on net. pls. write the address. Thanks in adv.Sujata, if you are talking about oracle apps, try following link http://etrm.oracle.com/pls/etrmlatest/etrm_search.search and for database table struc [More]
Hi there, I've just received my new retina MBP 15" and after getting it set up, I'm having issues with it not properly recognizing a MIDI device. The device in question is an Akai MPK49 keyboard and it worked fine on my previous Mac (2011 MBP) and I' [More]
Hello all I have LV7.1 I want to create application  I receive the error: Application Builder:  A Source File VI or one of its dependencies does not exist. Open all VIs in the Source Files list, recompile them, and save them to update their dependenc [More]
Hi, I have a proxy service with error handler at route level. when any wrong inputs are given to this proxy the Biz will generate fault with error as BEA-382108 having error message as XPATH can only be done for XML or MFL content. This is error is h [More]
hi all, I have problem when the installation of solution manager try to insert into secure store, the installation completed creating the secure store, but at the inserting the error raised... i need your helps, Thanks in advancedthi is the insallati [More]
Which telco did you prefer to use to make or recieve call while abroad using your Blackberry? Digi/Celcom/Maxis or any other mobile operator? Can you guys share the cheapest rate and roaming experience? TQ! Is data roam or communication is important [More]
Hello Experts, we have seperated the fixed planned orders  from the planned orders by creating a new category group which contains only EE fixed, leaving EE unfixed in Category Group FP1. We then assigned the fixed orders to a new KF. Now we have the [More]
Hi, I have mail stored in maildir format, a  lot of it encrypted with gpg. Is there any program to just batch decrypt the emails and keep them in plain text? gpg program itself doesn't work because after decrypting it just gives you the decrypted mes [More]