|
Replies:
7
-
Pages:
1
-
Last Post:
Feb 24, 2012 9:46 AM
by: Dwight
|
|
|
Posts:
11
Registered:
2/9/12
|
|
|
|
Object name with $ sign
Posted:
Feb 9, 2012 5:03 AM
|
|
|
Hi,
after Import Oracle Schema I've got table names with $ sign .. R$SOMETHING.osql for example.
And after that when I want rename file name I'm getting replace of $ to _ and can't change it.
Can I somehow rename file and use $ in file name ?
Thanks.
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Object name with $ sign
Posted:
Feb 9, 2012 12:10 PM
in response to: Newborn
|
|
|
Hmm,
I've never heard of R$XYZ tables before. Are they part of some package that you are using? Can you tell anything from the columns in the tables what they are used for or where they might have come from?
We filter out several Oracle generated table types. Especially for Advanced Queues. I would really like to know where those R$ table are coming from.
|
Dwight
|
|
Posts:
11
Registered:
2/9/12
|
|
|
|
Re: Object name with $ sign
Posted:
Feb 10, 2012 12:12 AM
in response to: Dwight
|
|
|
Hi,
table name R$XYZ appear from our internal rules for naming table objects, same as PAC$XYZ for packages and etc. It dosn't mean any special for Oracle.
Anyway I don't know any reason why we can't use this naming rules. Is $ sign forbiden in that cases?
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Object name with $ sign
Posted:
Feb 10, 2012 10:46 AM
in response to: Newborn
|
|
|
Newborn,
Okay. It was my misunderstanding. I thought you didn't want the R$xxx tables to be imported. Let me check what is happening in our rename routine. I suspect that we are translating the $ for a reason. Let me find out why.
|
Dwight
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Object name with $ sign
Posted:
Feb 10, 2012 11:18 AM
in response to: Newborn
|
 |
Answered |
|
|
Newborn,
The short answer is, "it's not our fault." This restriction is something that Microsoft has imposed on any database project. Since we are built on top of Microsoft's implementation, we are stuck with this limitation.
|
Dwight
|
|
Posts:
11
Registered:
2/9/12
|
|
|
|
Re: Object name with $ sign
Posted:
Feb 14, 2012 2:41 AM
in response to: Dwight
|
|
|
Hi,
thanks for answer. We'll think about changing rule or smth.
But in fact, it's very strange, because you can import tables with such names, and in same time can't rename to them. Very strange.
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Object name with $ sign
Posted:
Feb 24, 2012 9:42 AM
in response to: Newborn
|
|
|
Newborn,
The strangeness is our doing. Our code is called to do the actual file creation when you import DDL from a database. Only Microsoft's VS code is involved when you actually rename a file. We never get a chance to intervene. Their code has some kind of aversion to $ signs in the name.
I think it might have something to do with Microsoft's variable replacement technology. Don't they use the $ sign as an indicator of a variable replacement place-holder?
|
Dwight
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Object name with $ sign
Posted:
Feb 24, 2012 9:46 AM
in response to: Newborn
|
|
|
It turns out $ signs are not allowed by Microsoft's database project system code.
|
Dwight
|
|
|
Legend
|
|
MVP: 2501
+
pts
|
|
Guru: 2001
- 2500
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
