• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

ORA- 01652

hI GUYS,

i GOT THE above error  using this query,

is there away around this

Select Distinct
      case
      when e.Tax_period_id = 9 then '03/04' when e.tax_period_id = 10 then '04/05' else null end,
e.Emp_Name,
c.Reference_num,
c.case_name
from
client c, employer_details e
0
SirReadAlot
Asked:
SirReadAlot
  • 2
1 Solution
 
SirReadAlotAuthor Commented:
hi angel,

I know what the error is, but how do i do this

 
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have to add a datafile to the tablespace that indicates the error.

now, if the tablespace is the TEMP tablespace, the problem might be a completely other error.
Anyhow:
http://www.adp-gmbh.ch/ora/sql/alter_tablespace.html
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now