OraFAQ Forum: Server Utilities » Migration from postgress into oracle columns with spaces

Home » RDBMS Server » Server Utilities » Migration from postgress into oracle columns with spaces (Oracle 10.2GR Solaris 5.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migration from postgress into oracle columns with spaces [message #466957]

Wed, 21 July 2010 15:07

sinhora1
Messages: 7
Registered: July 2010
Location: Toronto

Junior Member

Hello
I have migrated from postgress to oracle entire databases however some tables have spaces how can they be removed and how can i found out all the tables in a schema with spaces?
thank you
Ana

Report message to a moderator

Re: Migration from postgress into oracle columns with spaces [message #466962 is a reply to message #466957]

Wed, 21 July 2010 15:26

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

some tables have spaces

What does that mean? What should they have, instead? NULL?

Report message to a moderator

Re: Migration from postgress into oracle columns with spaces [message #466963 is a reply to message #466962]

Wed, 21 July 2010 15:28

sinhora1
Messages: 7
Registered: July 2010
Location: Toronto

Junior Member

Yes, however after the migration from postgress to oracle which i used SQLLDR the data some columns came with spaces, so how can i see all tables which may be spaces and how to fix it

thanks
Ana

Report message to a moderator

Re: Migration from postgress into oracle columns with spaces [message #466965 is a reply to message #466963]

Wed, 21 July 2010 15:32

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can trim all columns without searching them.
Or you can reload in a correct way.

Regards
Michel

Report message to a moderator

Re: Migration from postgress into oracle columns with spaces [message #466969 is a reply to message #466965]

Wed, 21 July 2010 16:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator