Problem solve Get help with specific problems with your technologies, process and projects.

Problems creating new tablespace

I am having a problem with the creation of a new tablespace on the BW QA system. Everything was okay with the creation of the tablespace on the DEV and PRD systems for BW. On the QA system, it wanted a SID as part of the naming convention. For example, PSAP COP for the tablespace. On DEV and PRD BW system, it didn't ask for that. Also, on the QA system, I got the message, "Cannot be inserted into the ABAP-DDIC." What would be the difference between the QA system and the DEV/PRD system? The product is SAP BW 3.1, Database Oracle 9.2, and the operating system is Solaris 9. Please advise. Thanks.
You've included an Oracle version, but you've neglected any error message. There are a large number of reasons why you are not able to create your tablespace. Rather than guessing at what is causing your problem, I'd like you to repost your question. This time, run your CREATE TABLESPACE command and post both the exact command you used, and your error message that you received.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.