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
I got an iPhone 4 on Thursday. I connected it to my PC, a Windows Vista, that day and nothing showed up besides a "camera." My computer picked it up as a camera, which I understand is a common occurence in the iPhone. After browsing countless yo [More]
My partner and I share the powerbook and I use my iPad, Though we each log in with separate accounts all my pics and music are in both libraries .   Can I isolate accounts from iCloud ?Not quite sure exactly what you want to do, but you cannot do it [More]
We have two iPads, Apple TV, and use iTunes on Windows PC for our big music library. We enabled Home Sharing everywhere. So we use the same Apple ID on iTunes for all of those devices. That works fine. Now it seems that when my wife puts an app on he [More]
Hi, I am getting the Error while checking in and storing: C:\Users\abcd\Desktop\Hotel.docx Message no. 26253 while checking in the document to the content server. What may be the possible reasons from the configuration and basis side..please advice. [More]
Hi, I recently updated my ipod touch 3rd gen to ios5 (as prompted by itunes - assumed a standard software update). Immediately afterwards, my ipod went into recovery mode, and initially itunes recognised this and tried to restore it unsuccessfully. N [More]
This all started when i went on vacation and used the wifi the resort offered for free. After 2 days i noticed my device kept saying low memory so i kept deletig some pics and videos but nothing crazy because i knew the videos i were deleting were me [More]
I just registered to netflix on my appletv and missed the word "the" off the start of my email address, but registration was successful, its linked payments via my apple acct to somone elses email, and I can't remember the password. I know it wo [More]
Hi, I've used 30GB in 2 days and it seems to be coming from "124-149-191-162.dyn.iinet.net.au" on port 548 which is Apple Filing port, if you need any details just ask. Screen Shots of port and other This is just when I started the app (rubberne [More]
I bought my mother a 3rd gen 8gb Nano for Christmas. My ITunes library is huge. She has nothing. Could I register her iPod on my ITunes download a selection, and then do the same thing on her computer? I am thinking that the selection of music from m [More]
I'm running logic pro 9 on a mackbook pro and want to save sessions and store audio and jam pack content on a 7200rpm firewire 800 external hard drive. I installed the audio content on the external drive successfully but the installation software won [More]