Home » RDBMS Server » Server Utilities » Migration from postgress into oracle columns with spaces (Oracle 10.2GR Solaris 5.8)
Migration from postgress into oracle columns with spaces [message #466957] Wed, 21 July 2010 15:07 Go to next message
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
Re: Migration from postgress into oracle columns with spaces [message #466962 is a reply to message #466957] Wed, 21 July 2010 15:26 Go to previous messageGo to next message
Littlefoot
Messages: 19469
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?
Re: Migration from postgress into oracle columns with spaces [message #466963 is a reply to message #466962] Wed, 21 July 2010 15:28 Go to previous messageGo to next message
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
Re: Migration from postgress into oracle columns with spaces [message #466965 is a reply to message #466963] Wed, 21 July 2010 15:32 Go to previous messageGo to next message
Michel Cadot
Messages: 58847
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
Re: Migration from postgress into oracle columns with spaces [message #466969 is a reply to message #466965] Wed, 21 July 2010 16:12 Go to previous messageGo to next message
BlackSwan
Messages: 22688
Registered: January 2009
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/
Re: Migration from postgress into oracle columns with spaces [message #467181 is a reply to message #466969] Thu, 22 July 2010 08:32 Go to previous messageGo to next message
sinhora1
Messages: 7
Registered: July 2010
Location: Toronto
Junior Member
is there a select statment that can be done that shows if a table column has spaces etc?
Re: Migration from postgress into oracle columns with spaces [message #467183 is a reply to message #467181] Thu, 22 July 2010 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for find_string function on AskTom.

Regards
Michel
Re: Migration from postgress into oracle columns with spaces [message #467223 is a reply to message #467183] Thu, 22 July 2010 13:59 Go to previous messageGo to next message
sinhora1
Messages: 7
Registered: July 2010
Location: Toronto
Junior Member
thanks i figure it out

update TABLE set col1=trim(col1), col2=trim(col2);
Re: Migration from postgress into oracle columns with spaces [message #467225 is a reply to message #467223] Thu, 22 July 2010 14:09 Go to previous message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not what I said in my first answer yesterday?

Regards
Michel
Previous Topic: EXP vs IMPDP interrogating dump file
Next Topic: transportable tablespace
Goto Forum:
  


Current Time: Wed Aug 20 23:59:40 CDT 2014

Total time taken to generate the page: 0.05701 seconds