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
There are a lot of good comments on these ideas, but I can't quite figure out if I can do this or not. I have an 18GB partition on an external drive. I have OS X 10.6.8 (with BootCamp) and a Windows 7 Home Premium disc. If I install VirtualBox (on my [More]
Hi, I am getting the following warning message in backup log(DB12). I tried to check the at mirrlogA & mirrlogB. There are no files inside this folder. Need someone's interventions to solve this warning messages in DB12 backup logs. BR0335W Status of [More]
Hi All, In some standard queries system is calling stored procedure, How to find these stored procedure in CLM? I tried in setup but I am unable to find. Thanks for help. Regards, PrabhatFor accessing any stored procedure, you would need direct acces [More]
I have developed a simple stateless session bean. After being called once, the following is output to the log: Thu Jan 04 18:15:46 CST 2001:<I> <RJVM> Signaling peer 3978882810638278829C198.171.129.36 gone: weblogic.rjvm.PeerGoneException: - w [More]
I am in the process of building a website for a client and have included a google map on the contact page. The map displays correctly in ie, safari, opera, and chrome, but on firefox the map is way out of position on the page. Firefox seems to be ign [More]
My Battery Draining Very Fast after Updateing 7.1.1 Your device might keep syncing your Emails,  Contacts and some other applications.  Reboot your device in this manner, when the device On,  connect to the wall outlet charger and remove the battery. [More]
I was getting several iTunes charges a month that I did not make and they DON'T show up on my purchase list.  I changed my password and checked no form of payment and today I checked my credit card statement and there is a charge to iTunes for $12.98 [More]
Anyone know how I can order photo prints from the iPad in the UK. Currently have to switch my pc on which isn't idealThis app was just released:  http://itunes.apple.com/us/app/roes/id533327862?mt=8 It connects your images with Pro Labs around the wo [More]
I am using JDeveloper Preview version 10.1.3.0.2.223. Occasionally I encounter the following error when trying to deploy my application to a WAR file: ---- Deployment started. ---- May 2, 2005 3:15:28 PM Target platform is Standard J2EE. **** Unable [More]
I'm a very new Mac OS user so forgive me if this has been answered elsewhere or I'm just dumb and don't know what I'm doing. I'm trying to get some media files (WAV for example) to always open with QuickTime instead of iTunes. When I do Open With, Ot [More]